SSIS 2005 Data conversion & appending issues
Help please! I've got a SSIS package that takes a CSV file and populates a table with the output. I've got a total of 4 fields (two string, two date) I'm importing. The package runs without errors and populates the table with the correct record count. Here's the issue - the two string fields populate the table with what appears to be Chinese characters, and the two date fields don't populate at all. My code page is consistent (1252), and a data viewer I've placed between the derived column section and the SQL Server Destination section displays exactly what I want being appended to the table. Any thoughts? This has me stumped!
January 20th, 2011 3:20pm

Donot start 2 threads with the same content. it wont help you or others.
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2011 3:48pm

Grrr. Didn't mean to - I hate that. The "Submit" button didn't appear to work the first time. Apologies to all.
January 20th, 2011 3:54pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics