My objective to use SSIS to to pull data from DB2 and store into SQL Server.
Working environment is:
Database: DB2 UDB iSeries V5R3
Provider: IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider
SQL Server 2005 SP: Latest i-e SP2
In connection manager, i have changed the following properties in OLEDB driver settings and connection with DB2 is tested successfully.
1- CATALOG LIBRARY LIST = AS/400 library
2- PERSIST SECURITY INFO = TRUE
3- INITIAL CATALOG = Database Name
4- Defualt Collection = AS/400 library
After testing connection, I Created an OLE DB source and in OLE DB Datasource Editor set following properties:
1- VALIDATE EXTERNAL METADATA = FALSE
2- ALWAYS USE DEFAULT CODE PAGE = TRUE
In OLEDB source editor, if i use "Table or View" name option then the drop table list is populated perfectly and i can specify any table. With this option Package executes fine. But if i use the SQLCommand and specify the query, it prase the query correctly and i can preview the data in this source editor. But upon execution package return the following error message.
[OLE DB Source ] Error: An OLE DB error has occurred. Error code: 0x8
View Complete Post