So, I have an SSIS package that I'm wanting to create. When I use the ODBC connection (similar in the DTS), I can pull everything over fine. I have 2 fields, one is a Char(3) the other a Char(13) on the 400. I've made the exact table in my sql server db.
The problem is that if I use the ole for .net instead of odbc, I get the following Error when I switch the provider in the SSIS package:
I'm using the IBMDA400 OLEdb\IBM DB2 UDB for iSeries when I get the error
I'm not having this problem with any other of my SSIS packages... wierd.