In SQL Server 2000 I can easily push data to our AS400 using an ODBC connection - which then uses the Client Access (iSeries Navigator) drivers. For AS400's, using IBM's ODBC drivers are still the most desirable method.
Nonetheless, now I am trying to push data through SSIS but ODBC not a valid connection type in the data flow object. So, I am trying to use the OLE DB connection object "IBMDA400" and I am having troubles. I have verified that the OLE DB object is successfully connecting because I have been able to select the correct table and map all of the columns.
However, I am getting the following error on every single column (with the column name changing of course):
An OLE DB record is available. Source: "IBMDA400 Command" Hresult: 0x80004005 Description: "CWBZZ5014 Value of parameter GBMCU could not be converted to the host data type.".
Anyone out there successfully pushing data to an AS400 using SSIS. Any tips you can provide?
Thanks in advance.