Dealing with Foreign Language characters

[mossbs]

Hi guys,

trying to set up simple SSIS package to take data from one server (LIVE) to another (TEST).

When trying to execute it going from direct one server to the other the package was just failing.. so i thought i'd try exporting the data into a csv file to start to see if that worked.

However, the package is erroring (going red) on my data flow .. but not producing an error number/msg.

After checking the csv file I think that the problem is that the data i am exporting contains foreign language characters. data is being written to the csv but stops on the colulmn that would have these characters in.


(example of characters.... ???? ???????)

is there any way around this?

cheers,

dan

 

[mrdenny]

Make sure that everything with in the SSIS package is setup for unicode characters.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog