argg.. UTF-8 troubles

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » argg.. UTF-8 troubles

argg.. UTF-8 troubles

Rate Topic

Display Mode

Topic Options

Author

Message

Erin Ramsay

Posted Wednesday, October 26, 2011 11:42 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 1:44 PM
Points: 419, Visits: 773

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

Post #1196538

tan110

Posted Wednesday, January 16, 2013 6:43 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 6:54 AM
Points: 146, Visits: 611

Have you tried a data conversion step?

Post #1407810

« Prev Topic | Next Topic »

Permissions