Is there any way to resolve validating error when exporting data from SQL Server?-CodePudding

Home > Enterprise > Is there any way to resolve validating error when exporting data from SQL Server?

Is there any way to resolve validating error when exporting data from SQL Server?

Time：07-12

CodePudding user response：

I think you might be using the Import / Export Wizard in SSMS, which opens up when you right click and choose Tasks > Export Data.

In this case, when you configure the flat file destination, change the collation to 949 - ANSI Korean (the default is 1252). You may also need to check the unicode box depending on the source, but I would test without it first:

Page link：https//www.codepudding.com/Enterprise/472307.html

Prev:Extract string data between specific points in Oracle SQL

Next:self join table to get hierarchy for specific root node

Tags：

sql

sql-server

ssis

export-to-csv

Links：
CodePudding