dts failure 80004005

[beechill4]

Hi,

I get the following error message in my logs when running a dts package:

Step 'DTSStep_DTSActiveScriptTask_4' was not executed

Step 'DTSStep_DTSExecutePackageTask_6' was not executed

Step 'DTSStep_DTSExecutePackageTask_5' was not executed

Step 'DTSStep_DTSExecutePackageTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description1:SUN_TO_DWH_UPDATE_ACCOUNTS_ANALYSIS) SubStep 'DTSStep_DTSDataPumpTask_2' failed with the following error:
The task reported failure on execution. (Microsoft OLE DB Provider for SQL Server (80004005): The statement has been terminated.) (Microsoft OLE DB Provider for SQL Server (80004005): INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_FIN_ANALYSIS_CODES_FIN_BUSINESS_GROUP'. The conflict occurred in database 'DATAWAREHOUSE_FINANCE', table 'FIN_BUSINESS_GROUP', column 'BUSINESS_GROUP_CODE'.)
Package failed because Step 'DTSStep_DTSDataPumpTask_2' failed.
Step Error code: 80040428
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100


any idea on how to debug this?

 

[unclerico]

this looks like referential integrity has been violated...have you got a matching value in the table on the 1 side of the 1:M relationship??