title: SSIS Convert Unicode 65001 to ANSI 1252
body: <p>I am working with SSIS to import a CSV. The the package has been working for several years now to import 10K rows into a SQL Server Table. The provider of the source file has switch to a Unicode 65001 system. I have had no luck converting this into something my SQL Server 2008 database can use. Things I have tried include : Add a conversion step converting to [DT_STR] 1252 ANSI, Changing all the columns in the database to NVARCHAR from VARCHAR, create whole new table of NVARCHAR, Copy the Flat file and change line endings, Transfer the File to a Stage table. In all case I get the same error "Cannot convert between 65001 and 1252. I have done similar things from Oracle databases and the conversion step has worked. Note, there are no unicode characters in the file, it is generated out of an Oracle system.</p>