When iam trying to load the table from source to destination iam getting the following errors can anybody help me out ,both my source and destinations are DB2 and i have used IBM OLEDB Providers for both source and destination and i destination table i have added an additional column which is already present in source table in order to move the data ,any help can appreciated Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "IBM OLE DB Provider for DB2" Hresult: 0x80004005 Description: "[DB2/AIX64] SQL0668N Operation not allowed for reason code "7" on table "CTMS.CAR_INFO". SQLSTATE=57016 ". Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (56)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (56)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component CAR_INFO" (43) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (56). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.

ay be an access issue... you may need to reorganize the table Check the link below - http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.msg.doc%2Fdoc%2Fsql0668.htm Explanation: Access to table table-name is restricted. The cause is based on the following reason codes reason-code: -> The table is in the reorg pending state. This can occur after an ALTER TABLE statement containing a REORG-recommended operation. Fix: Reorganize the table using the REORG TABLE command (note that INPLACE REORG TABLE is not allowed for a table that is in the reorg pending state).

thank you very much for your prompt reply i did reorganized the table using REORG TABLE command but still iam getting the same errors