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, 8 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?

Hi

The 2nd table will only have 1 entry for the person employment status from the first table whether it would be "Manager", "Fired" or "Enjoy Life". It will not...

Don't use OLEDB Command for updates ... unless your number of updates is tiny. It's dog slow.

Instead, direct all of your update rows to (yet) another staging table (as INSERTs),...