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
Posted by at
Labels: ,

7 comments:

  1. AnonymousOctober 14, 2011 at 1:59 PM

    thanks it was help full

    ReplyDelete
  2. AnonymousMarch 16, 2012 at 3:25 PM

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

    ReplyDelete
  3. AnonymousJune 11, 2012 at 4:43 PM

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

    ReplyDelete
  4. AnonymousSeptember 10, 2012 at 1:43 AM

    Great solution

    ReplyDelete
  5. UnknownMay 29, 2014 at 9:49 AM

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

    ReplyDelete
  6. AnonymousJune 17, 2014 at 3:11 PM

    It worked

    ReplyDelete
  7. AnonymousJune 20, 2014 at 8:04 AM

    Thank you! It worked for me too.

    ReplyDelete

Subscribe to: Post Comments (Atom)