I'm importing a UTF-8 flatfile through ssis and when I use the normal ado.net target connection to import the process runs just fine though a little slow. To speed things up I switch to SQL Server target (to bulk import the files) and it tells me it can't process because the source is UTF-8 code page 65001 and the destination table is code page 1201. However I can't seem to find a UTF-8 code page in sql server 2008 to match up. I'm sure someone else has come across this and solved it. Suggestions?
Don