April 1, 2010 at 5:28 am
I want to put on a dataflow task from SQL2005 table to DB2.
2 Tables are the same for layout.
2 Fields Unicode string [DT_WSTR]
6 Fields Four bite signed integer[DT-I4]
Have a OleDB connection with expression in connectionstring =
"Data Source=DB2G;UID=on4ciq;Provider=IBMDADB2.1;Persist Security Info=True;Location=;Extended Properties=;PWD="+ @[User::pwd] +";"
Where pwd = variable and declared in variables.
Have testet the connection with a read function in SSIS and I can read the DB2 table and put in a flatfile but i am not able to write to the DB2 Table.
I am owner of the table and got all rights to insert, update, delete.
The 2 msgg i get when execute the SSIS :
[OLE DB Destination [76]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
[DTS.Pipeline] Error: component "OLE DB Destination" (76) failed the pre-execute phase and returned error code 0xC0202009.
Is there someone who can point me in a direction after a 2 day's search pls ?
April 12, 2010 at 12:51 am
Re: Move data to DB2 on AS400 with SSIS
Try this thread from BJ Custard.
The configuration steps are as follows...
1.Create a Data Source for the AS/400, using provider NATIVE OLE DB\IBM DB2 UDB FOR ISERIES IBMDA400 OLE DB PROVIDER, WITH THE FOLLOWING CHANGES
?CATALOG LIBRARY LIST is the AS/400 library
?USER ID should be populated
?PASSWORD should be populated
?PERSIST SECURITY INFO should be TRUE
?DATA SOURCE should be your machine DNS name (tho IP might work)
?INITIAL CATALOG should be the actual machine name (mine is populated when I click on the dropdown)
2.Create a Connection Manager for the above data source
3.Create an OLE DB source/destination...
?OLE DB Connection Manager from above
?Data access mode = Table or View (or SQL Command for a OLE DB Source)
?Name of Table/View should be <Catalog Library List>.<Table>. If you config is correct, this dropdown will contain a list of them to select from...
?On the 'Advance Editor' screen, under Component Properties, set
¦VALIDATE EXTERNAL METADATA = FALSE
¦ALWAYS USE DEFAULT CODE PAGE = TRUE
4.We had to turn on JOURNALLING on the DB2 tables to write to them. (This may or may not be a requirement...)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply