I have this problem:
In a DTS package I can connect to a DB2 on an AS400 and execute a stored procedure. I can then import this data into a table.
I can't do this in SSIS. DTS uses an ODBC connection. I have tried this with SSIS 2008 r2 – I can use a ado.net connection which picks up the ODBC driver.
I pass in the stored proc as a sql command.
I click preview and all the data is there. I click columns and none are defined.
Has anybody gotten this to work? It seems like a step back to me- DTS did
View Complete Post