Our experience is that we can have no more than 3 SSIS packages pulling BW data at the same time. There is no rhyme or reason to it. ...

My apologies. Since this is both SQL Server and Data Warehouse question I was not sure where to post so I just used both forums.

Nancy

I believe this is what I need. I can use the loginame from SP_WHO and feed it to xp_logininfo to see the AD Group the user was authenticated by....

We do have both an identity column and indexes on the target table. I'll look at those next.

By using the Microsoft OLE DB for DB2 provider the...

After some additional research I tried changing the OLE DB provider from IBM to Microsoft OLE DB for DB2. Using the Microsoft driver the test package ran in...