February 24, 2013 at 2:03 am
Dear Experts
I am trying to export data from table to a flat file but this error recured on several fields
Error 0xc00470d4: Data Flow Task 1: The code page on input column "patient_id" (439) is 1252 and is required to be 1256.
(SQL Server Import and Export Wizard)
any idea how to solve this problem, thanks
February 25, 2013 at 12:39 am
Try to change all varchar/char to nvarchar/nchar. You could do this either trough a view, or trough data conversion in ssis.
Greetz
Query Shepherd
February 26, 2013 at 4:49 pm
I would save the package and then create a solution and add the package to the solution.
Then you may edit the code page.
Saving the package and running it should provide you with more details and flexibility.
HTH.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 17, 2013 at 4:04 pm
Wondering if this got resolved. If so can you share how? thanks.
----------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply