Hello,

I noticed that SQL Server 2005 SP3 is not in the in the supported version to be upgraded to SQL Server 2008 R2 as shown in the link below....

It's tough to beat well-written SQL scripts, but it's also quite rare...

Unfortunately, your flexible architecture has resulted in a performance trade-off which is not easily remedied.

If you can buy and install third party products, you might like to think about

Indeed I did. I believe that yours demonstrates that you did not read mine.

Why are you persisting with Results to Text after I told you (implicitly) that this does not...

Did you even read my response?

You mean 'Results to File'?

You will be prompted for a file name/location when you execute the query.

Results to Text puts the results into the Results pane, in text format.

• This reply was modified 6 years, 5 months ago by Phil Parkin.

I'm just waiting for Jeff to chime in on this one ...

One possibility would be to add a 'WorkerNumber' (INT) column to your JobExecution table. Let's say you have 20 jobs, which would equate to 4 groups, each containing 5 jobs.

Now...

I don't have any links to hand.

But what I will say is that you should think of SSIS as a streaming tool.

Transformations are applied to data as it streams along...

A SQL transform would require access to a DB engine. To make use of that engine would require the passing of data to the engine and the subsequent retrieval of...

You can't. If you want to use T-SQL, you need to use the DB engine (and not SSIS). You'll likely have to rewrite your existing code to make best use...

What are the exact criteria for defining a row as 'Inactive'?

Do any of your dealer names contain an ampersand (&)? That might do it.

The...

Most people here won't open Excel documents from the Internet.

Can you use text files, or simply cut & paste the code, instead?