Wednesday, March 16, 2011

SSIS Error On OLE DB Command - Operand type clash: int is incompatible with date

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.
http://connect.microsoft.com/SQLServer/feedback/details/628743/ssis-oledb-command-date-datatype-in-stored-procedure-sqlcommand-yields-operand-error

7 comments:

  1. thanks it was help full

    ReplyDelete
  2. Its wierd but this problem persists.
    thks for your solution :)

    ReplyDelete
  3. The better part of 2 days I spent trying to figure that out - thank you for your post!

    ReplyDelete
  4. Thanks for your solution it worked, but this kind of problem is frustrating for a developer.

    ReplyDelete
  5. Thank you! It worked for me too.

    ReplyDelete