Yes, I setup the AS400 as a linked server on our SQL 2005 box and pull and push data that way. The linked server definition will still allow you to use ODBC...thereby creating a usable ODBC connection for SSIS.

It used to be with SQL2000 that the linked AS400 servers could be used to pull data but not push to them. Apparently SQL2005 has improved something because I can now update the AS400 linked server without getting MSDTC errors!

Good luck.

Ryan