I think that is a good analogy..

CEWII

I *largely* agree with your issues. There is no hard and fast rule about 1 file per core or CPU. An aweful lot depends on your disk subsystem...

I think I need to qualify this answer..

A single query will only be run against a single connection. What that means is that for something like an EXEC SQL...

Find - Replace, should be REALLY easy..

If you understand why temp tables are a problem it might make more sense.

For performance reasons SSIS wants to have several connections open, so...

Create a persisted table in tempdb like tempdb.dbo.yourtemptablename and clean it out when you are done.

E.

SSIS has trouble with temp tables. There is a setting on the connection that *may* help. That setting is "RetainSameConnection", you can set it true and it might...

It should be near the top of the list. If not you can right click on the toolbox and click on "Choose Items". Be sure to go to...

This line on that...

Could you provide a link to ESW?

CEWII

I can think of a few things. First, what logging are you doing? If you aren't doing any stop, go back and add some, this is hard enough...

Do you have "objvariable" in the readonly or readwrite variables?

CEWII

I can't find the article right now, but it changes the access method and cursors, locking, etc when getting the data. To the point that as a rule, I...

I read that as you having picked the view out of the list. If so, replace it with a SELECT * FROM dbo.ViewName. I think you will find...

I went back to the original error:

"Cannot get a row from the provider OLE DB "BULK" from the connected server "(null)".".

This is indicative of the provider having trouble getting rows...

So what errors is it giving now?

CEWII