As mentioned above, I also am a DBA in charge of backing up to disk, my SysAdmin handles the back up tape. However, that is where the distinctions end. I...

I htink this is a pretty cool technology, I first read about it as a concept a few years ago. Looks like practical applications are already in development:

http://www.computerworld.com/hardwaretopics/storage/story/0,10801,106288,00.html

Hi-

Can you just change the data type on the DB2 DB temporarily to char or varchar and see what happens? Then change it back once the data is in.

Make sure your connections within the package are changed to reflect the new server name. Or localhost works too.

Here is a good link:

http://vyaskn.tripod.com/sql_server_dts_best_practices.htm