I have found that the MS DB2 OLEDB works much better. The only issue is that you have to have SQL Server Enterprise. It still behaves badly though. I was trying to load a flat file to the 400 and it would error. I load the flat file to a SQL Server table and then to the 400, works fine.
I have lots of problems loading into date data type columns on the 400 as well.
Steve Fibich has a serveral blog entries on working with SSIS and the iSeries. http://vsteamsystemcentral.com/cs21/blogs/steve_fibich/default.aspx
Norman
DTS Package Search