Member Avatar for jjfletch

I'm using SQL Server 2008, the SQL Server Management Studio. I'm trying to import from a flat text file into my mssql database, but it inevitably fails, resulting in the error:

The column "Column 2" cannot be processed because more than one code page (65001 and 1252) are specified for it

I googled and whatnot, and saw the suggestion to set AlwaysUseDefaultCodePage to true, but I can't find that setting anywhere! Is there a way to do this from with the management studio or set via query or something?

  • 2 Contributors
  • 1 Reply
  • 117 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for Ramy Mahrous

Give me sample row in the text file and table structure (columns and datatypes)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.