• Just following up on this...hoping for some suggestions/info on the following:

    - the convesion document is great but it doesn't say where to enter the conversion expressions in SSIS.  Everywhere I have tried has generated an error.  Anyone know?

    -Is there any way to use ODBC with SSIS?  IBM still recommends their ODBC driver as the preferred method for pushing and pulling info for DB2/400.  My SQL 7 and 2000 DTS packages using the data pump over ODBC work great.

    -Is anyone out there currently pushing data to their AS400 using SSIS in any fashion?  If so, I would be glad to follow suit using whatever method.

    Thanks in advance.