March 10, 2017 at 6:51 am
I'm querying an oracle database with SSIS to pull some data out to a flat file. The flat file needs to have a code page of 1252 - Latin so that it can be consumed by a 3rd party system. One of the fields that I am pulling out is a Description with a Varchar2 data type, and if I change the file to UTF8 it works fine, but when I set the code page to 1252 I get this error. "one or more characters had no match in the target code page" Does anyone have any ideas on how I can export this column to a flat file with a 1252 code page? Is the issue that the source column is a varchar2? I tried CASTing it as Varchar in the source query but that didn't help. Any ideas/help is appreciated!
March 20, 2017 at 1:08 pm
If you view the metadata of the dataflow (double click the line coming out of your source) i assume that column shows up as a DT_WSTR.
If so use the following to convert. you can also use a data conversion task but my preference is always a derived column.
Derived column <add as new column> with the expression:
(DT_STR,<length>,1252)YourDescriptionFld
Specify the length as your source column length, if its less you'll need to substring or something.
Use this column instead of the original for the remainder of the data flow.
hth,
Tom
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply