Post reply

Invalid character value for cast specification SSIS error

  • August 20, 2009 at 8:54 pm

    #203990

    I am passing smalldatetime datatype as parameter for my sql source extract in the ssis package. Its throwing an error "Invalid character value for cast specification". Could somebody help how to fix this error?

  • August 21, 2009 at 6:22 am

    #1042759

    Are you perhaps using a date format that SQL doesn't like? I have great difficulties dealing with US dates vs EU dates. to save hassle I always use dates in the format DD MMM YYYY e.g. '01 Jan 2001' alternatively it might be one of your stored procedure's output columns not conforming to the datatypes described within your SSIS package itself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply