Here's a good one - Operand type clash: int is incompatible with date.
It appears, although I have not fully confirmed, that SSIS does not play well with the new SQL Server DATE data type.
I ran into this issue when calling a stored procedure from an OLE DB Command transformation. The stored procedure had a parameter of data type DATE.
While not entirely satisfying, the quick fix for this is to change the parameter data type to DATETIME.
An issue was opened with Microsoft but they state they have not been able to reproduce the error.
thanks it was help fullReplyDelete
Its wierd but this problem persists.ReplyDelete
thks for your solution :)
The better part of 2 days I spent trying to figure that out - thank you for your post!ReplyDelete
Thanks for your solution it worked, but this kind of problem is frustrating for a developer.ReplyDelete
Thank you! It worked for me too.ReplyDelete