Post reply

Unicode import problems

  • July 10, 2006 at 12:10 pm

    #113716

    I am trying to import some data from a remote Teradata database to my SQL Server 2005 using Intergration Services. When I did it with SQL Server 2000 and DTS, it would pull strings in as strings, and I applied them to Varchars. In 2005, It is pulling the strings in as Unicode strings, and I cannot convert them to strings, so they are not applying to the Varchar field. Anywhere in the process that I am trying to change a Unicode string, I get an error. Changing my SQL Server DB to unicode is not an option.

    Has anyone ran into this problem, and is there (I pray) a quick and easy solution to it?

    Thanks in advance,

    Shalom!,

    Michael Lee

  • July 11, 2006 at 8:54 am

    #648497

    I've run into the same problem with bringing UNICODE data over from an iSeries DB2 database.  Here's how I ended up handling it:

    On the data flow task, I have a data conversion transformation task.  In Advanced Editor, on Input/Output Properties, Data Conversion Output, I changed the data type of the output column from DT_WSTR (UC) to DT_STR (String).

    Hope that helps.

    Dan

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

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