I've had problems with this for sometime and it's driven me nuts.  Here's my experience:

Even though the microsoft ole db provider for DB2 shows up in the drop down list...

Kevinsql7 - I have the same problem but since I needed to do PUT statements, the DTS ftp wasn't even an option.  I haven't settled on a solution yet but I'm...

If you are fighting with Excel, this doesn't have error trapping for when the table DOES NOT exist but (if you're not too concerned about that scenario happening), this works...

Sorry to respond so late...

I would desperately like to have four part names work. Maybe I missed something, can you clarify? Our DB2 people were clueless and acted...

I'm a novice but... I went serious rounds with this and was never able to get the OLEDB Provider working. Host/SNA isn't available to us. We ended up...

Did you configure a linked server or are you just connecting on the fly within DTS?