Post reply

Destination table date field data types are often changing into String data type automatically

  • June 1, 2012 at 5:45 am

    #258956

    Hi Guys,

    In my destination table, i have a date field with DB_Databasetimestamp. but when i browse the table in the OLE DB destination in our SSIS 2008, the date field is showing Unicode String.

    So i have deleted the destination and tried adding it once again. still showing the same error.

    i have also tried closing and opening the solution. but still the issue is persisting.

    kindly give a solution to this issue.

    Thanks.

    Thanks & Regards,
    Shriram.

  • June 1, 2012 at 8:20 am

    #1495890

    Is your destination SQL Server, a file? You say it has a DB_Databasetimestamp data type but that is an SSIS Expression type (actually the type is DT_DBTimeStamp), not a SQL Server type. Your SQL Server data type should be either DateTime or SmallDateTime. If you are going to a text file of some sort, I don't believe that text files have data types outside of text types so you are stuck until you get the data into a more strongly typed environment.

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

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