Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

export to flat file is failed Expand / Collapse
Author
Message
Posted Sunday, February 24, 2013 2:03 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:17 AM
Points: 90, Visits: 239
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
Post #1423398
Posted Monday, February 25, 2013 12:39 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 19, 2014 5:41 AM
Points: 118, Visits: 355
Try to change all varchar/char to nvarchar/nchar. You could do this either trough a view, or trough data conversion in ssis.

Greetz
SQL Pizza



sometimes you dont see the pizza for the toppings...
seek and ya shall find...
Post #1423487
Posted Tuesday, February 26, 2013 4:49 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 10:57 PM
Points: 4,242, Visits: 4,290
I would save the package and then create a solution and add the package to the solution.

Then you may edit the code page.

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/8f0d2a85-1c66-4498-a04f-9353ad1dba03.

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/

Post #1424285
Posted Friday, May 17, 2013 4:04 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 4:50 PM
Points: 358, Visits: 876
Wondering if this got resolved. If so can you share how? thanks.
Post #1454204
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse