Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Problem with foreign characters.

Author  Topic  mossbs Starting Member 11 Posts Posted - 2010-10-01 : 06:46:08 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.... ?F?? ???????) is there any way around this? cheers, dan