November 22, 2013 at 11:15 am
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
November 25, 2013 at 9:32 am
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
November 25, 2013 at 9:33 am
duplicate response - rubbish internet connection here 😀
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply