question

sromans avatar image
sromans asked

SSIS package from sql database to ISeries

I'm writing an SSIS package to send data from a SQL 2005 database table to an ISeries file. I get to the OLE DB DESTINATION step. I select my ISeries connection (IBM DB2 UDB for ISeries IBMDA400 OLE DB Provider). I go to Advanced Editor and select the connection in the CONNECTION MANAGER drop down box. I select the COMPONENT PROPERTIES tab and enter the ISeries library/filename in the OPEN ROWSET property at the bottom of the screen (this file exists and has data in it). I click OK and get the following error:

Error ad Data Flow Task[OLE DB Destination [208]]; Opening a rowset for 'PLCUSTT/CLPCADU' failed. Check that the object exists in the database.

ssisoledbtroubleshooting
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.