SQLTeam.com | Weblogs | Forums

SSIS COnver between unicode and NOn-Unicode error

Hi i am getting this error when integrating CSV to SQL. i know you can use the advanced editor and change each field to Data Type: Unicode String[DT_WSTR]

But i have about 400 coulums. Is there an easier solution?

SSIS / DTSX packages are simply XML documents. You can open the DTSX file in a text editor and do a find/replace. I've done similar changes, but not exactly the one you want, so can't vouch that it would work (it might make the package invalid). Just make sure to keep a copy of the original files.