argg.. UTF-8 troubles

  • I'm importing a UTF-8 flatfile through ssis and when I use the normal 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?


  • Have you tried a data conversion step?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply