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?