Hi
I am getting below error in ssis package. Package contains Transfer SQL Server Object Task which Replace Data in destination table.
I have source dimension table from which I am replacing data in destination dimension table.There is no FK constraint present on source & destination dimension table which may not allow truncate table. Your help on this is appreciated.
SMO properties : CopyData : True ExistingData : Replace TablesList : Dimension table name
Code: 0xC002F325 Source: Copy Data to DW Transfer SQL Server Objects Task Description: Execution failed with the following error: "Truncate data failed for Table 'dbo.DimTable'. ". End Error Error: 2010-01-20 13:11:57.60 Code: 0xC002F325 Source: Copy Data to DW Transfer SQL Server Objects Task Description: Execution failed with the following error: "An exception occurred while executing a Transact-SQL statement or batch."