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

SSIS codepage isssue Expand / Collapse
Author
Message
Posted Friday, November 22, 2013 11:15 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 3:02 PM
Points: 320, Visits: 441
I'm using SS2k12. Trying to write a simple SSIS package to import a flat file to an identical table...

...Flat file is .csv, created by corporate (SSRS) report center, very vanilla, and not large, maybe a couple thousand rows....

I used the SSIS source wizard, pointed it to the flat file, told it to "suggest data types", etc.
I used the SSIS destination wizard, pointed to my database, and told it to create a new table

I get a message saying it cannot run because the source code page and destination code page are different (65001 and 1252.)

Now, since I'm at the very beginning, and have the ability to fix this by recreating any of the objects, what's the way to solve this once and for all? I don't need Unicode, these are all simple text, date, and numeric fields. On the other hand, I don't care, since there is further processing later and the output table is only an intermediate table.

How do I keep this from happening?


Jim
Post #1516882
Posted Monday, November 25, 2013 9:32 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 22, 2014 1:34 PM
Points: 58, Visits: 197
Don't use the source wizard and specify your data types? you should be able to get round it with that.
Allow your destination object to create the table once you have your data types correct (always name the component first to be the name of the table you want - saves creating the wrong table name when you forget to modify the script)

hope that helps
Post #1517337
Posted Monday, November 25, 2013 9:32 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 22, 2014 1:34 PM
Points: 58, Visits: 197
duplicate response - rubbish internet connection here
Post #1517339
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse