Post reply

time data type in ssis

  • October 25, 2012 at 9:49 am

    #283562

    hi

    in my databse i have 1 field as time data type

    now when i create variable in ssis , i dont find time ,so put datetime

    now in execute sql task, i need to ,map my parameter, again here i dont find time so i am putting

    dbtime2(oledb) connection

    getting error"unsupported data type"

    any help?

  • October 25, 2012 at 11:23 am

    #1552832

    I have not done this but if you use the dbtimestamp it should allow implicit conversion between the two. You could also use an ADO connection and try the Time type.

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

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