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: Tuesday, February 11, 2014 12:02 PM
Points: 89, Visits: 233
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: Thursday, April 10, 2014 8:04 AM
Points: 116, Visits: 337
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: Saturday, April 12, 2014 4:30 PM
Points: 4,050, Visits: 4,190
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


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:20 PM
Points: 220, Visits: 695
Wondering if this got resolved. If so can you share how? thanks.
Post #1454204
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse