Post reply

Cannot Convert between unicode and non-unicode string data types

  • June 26, 2008 at 3:46 pm

    #189855

    I am inserting data from query into table on SQL 2005 via SSIS package and receiving the error telling me that it cannot convert between unicode and non-unicode data types. I changed the source and the destination datatypes but still cannot get it to work. I am inserting DATENAME(MONTH,StartDate) as Month into the table Month_Nm (nchar(10))

    I can insert the data via query analyzer but it chokes in SSIS package

    Need Help!

    Thanks:D

  • June 26, 2008 at 3:56 pm

    #835015

    You need to use the data conversion in ssis.

  • June 27, 2008 at 8:11 am

    #835366

    How do you do this??? I am just starting with it...

  • June 27, 2008 at 8:23 am

    #835375

    Open up the toolbox in the left side of the data flow tab, there you can locate the data conversion tool from the data flow transformations section, drag this to the data flow area and delete the existing transformation link, configure the conversion and then remap the fields. A bit of trial and error may be needed, it is not that intuitive, but once done it is easier next time. If you are still having issues and have the $ to purchase a book, a good one is

    Professional SQL Server 2005 Integration Services http://www.amazon.com/Professional-Server-Integration-Services-Programmer/dp/0764584359/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1214576518&sr=8-1

    Andrew

  • June 27, 2008 at 8:26 am

    #835378

    Really appreciate your help... I'll try it now

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

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