September 3, 2010 at 10:40 am
Hi All.
I have this scenario where i have a ETL package and scheduled to run every day.It was running fine till yesterday but today i got this error i cant find what might caused to fail the package.
09/01/2010 02:00:00,Daily VGEN Cubes,Error,1,CORP-REPORTS,Daily VGEN Cubes,Process All VGEN_Cubes Staging Dimensions,,Executed as user: VGEN\SQLService. ...ion 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:00:00 AM Error: 2010-09-01 02:00:52.35 Code: 0xC0202009 Source: Load Procedures Dimension OLE DB Destination [8086] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unspecified error". End Error Error: 2010-09-01 02:00:52.36 Code: 0xC020901C Source: Load Procedures Dimension OLE DB Destination [8086] Description: There was an error with input column "Description" (9895) on input "OLE DB Destination Input" (8099). The column status returned was: "The value violated the integrity constraints for the column.". End Error Error: 2010-09-01 02:00:52.36 Code: 0xC0209029
Any help highly appreciated.
Thanks
September 3, 2010 at 11:45 am
srathna77 (9/3/2010)
Hi All.I have this scenario where i have a ETL package and scheduled to run every day.It was running fine till yesterday but today i got this error i cant find what might caused to fail the package.
09/01/2010 02:00:00,Daily VGEN Cubes,Error,1,CORP-REPORTS,Daily VGEN Cubes,Process All VGEN_Cubes Staging Dimensions,,Executed as user: VGEN\SQLService. ...ion 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:00:00 AM Error: 2010-09-01 02:00:52.35 Code: 0xC0202009 Source: Load Procedures Dimension OLE DB Destination [8086] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unspecified error". End Error Error: 2010-09-01 02:00:52.36 Code: 0xC020901C Source: Load Procedures Dimension OLE DB Destination [8086] Description: There was an error with input column "Description" (9895) on input "OLE DB Destination Input" (8099). The column status returned was: "The value violated the integrity constraints for the column.". End Error Error: 2010-09-01 02:00:52.36 Code: 0xC0209029
Any help highly appreciated.
Thanks
It looks like you have a problem with a referential integrity constraint with the Description column. Does that make sense?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 3, 2010 at 11:52 am
Ok got it.
Thank you sir.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply