This is fantastic bit of information and really useful.

Could I ask an additional question.

I have a SSIS package that currently exports from DB2 AS400 into SQL 2005 - all fine.

I now need to feed data back into the DB2 AS400 (ideally using SQL statements) I know the datareader destination requires a script to be written for the destination component, but instead can I use this new

OLEDB Provider for DB2 from Microsoft instead?

for writing to DB2?

hope this makes sense!