VS 2008 - Works one day but not the next
Posted on 2014-08-11
One day I was able to execute this SSIS package and everything was working great.
Same SSIS package and I get this error:
Error: 0xC002F210 at Clean up History and Inbound Tables, Execute SQL Task: Executing the query "EXEC Purge_By_FileId ?,?,?,?
" failed with the following error: "Operand type clash: int is incompatible with date". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Clean up History and Inbound Tables
I have not done any changes to the SSIS package
There has been a computer name change
There are 4 parameters:
VS2008 - SSIS 2008:
Fileids, Input, Long, 0, -1
Tblnms, Input, Varchar, 1, -1
StartTime, Input, DATE, 2, -1
ReRunFlag, Input, Long, 3, -1
SQL Server 2008 - Stored Procedure
@FileId int, -- File_Id from Database_Tables CLAIM
@TBLNM varchar(40), -- Table Name from Database_Tables
The parmaters are in order on both the SSIS and SP
Please help and thanks.