1. [OLE DB Destination ] Error: 2. [DTS.Pipeline] Error: 3. [DTS.Pipeline] Error: in SSIS Package execution
Friday, August 31, 2012 9:36 PM
I was told to assign primarykey for column named TCID in the detination. i changed the NULL to NOT NULL to assign a PK. i have done with the data conversions and i got the following errors in the Destination. please advice me to get rid of these.
[OLE DB Destination ] Error: An OLE DB error has occurred.
Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005
Description: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005
Description: "Cannot insert the value NULL into column 'TcId', table '*****.dbo.Accounts'; column does not allow nulls. INSERT fails.".
[DTS.Pipeline] Error: The ProcessInput method on component "OLE DB Destination" (6556) failed with error code 0xC0202009.
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.
[DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0202009.
Friday, August 31, 2012 9:39 PMThe message clearly says "column does not allow nulls, insert failed" which means that the source column mapped to TCID column has null value for some rows. Fix the source to stop sending null for this source column.
- Proposed As Answer by Todd McDermidMVP, Moderator Friday, August 31, 2012 11:07 PM
Sunday, September 02, 2012 8:32 PMModeratorand if you want to catch records that have null values in tcid column which caused this problem, you can use CONFIGURE ERROR OUTPUT and redirect bad data rows to another destination and run the package to troubleshoot it.