July 10, 2006 at 12:10 pm
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,
Michael Lee
July 11, 2006 at 8:54 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply