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 ]; Opening a rowset for 'PLCUSTT/CLPCADU' failed. Check that the object exists in the database.