Update:

I have refined the problem. The error is with SSIS(64bit). We can run a package succuessfully if we use DTEXEC (32bit) mode.

We will be opening a Microsoft...

we are using the ole db driver.

I would agree that it would be a IBM provider if the same query would fail when ran by DB2 command line.

How can SSIS...

I was having a very similar issue pulling data from DB2 and then loading back to db2. Inserting 100K rows would take up to 1hr to insert. I...

I have question too, is there a way in SSRS 2005???

Changing the run times of the jobs did not help at all.  Anybody have any suggestions?

Thank you,

Kevin

I changed the schedule to delay by 5 min for the packages we will see if that works.  My theory is that it wont change anything, I say this because...

Crispin,

I have SP2 installed but I have not applied the post SP2 patches.  I read through the post sp2 patches but did not see anything that might fix this issue, although...