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.