December 11, 2014 at 8:00 pm
Hi, all
I got that weird situation when I tried to get SSIS error redirection sample, my flat file stored as ANSI, without Error Redirection it works fine with cnmgr set to 1252, which load records to db Test.TableA ( code on this db also defaulted to Latin 1252).
When I turn on Error redirect and try to load Error records into Test.TableErr I got an error about 2 codepages...
I see that this field <Flat File Source Error Output Column> has CodePage=65001 and can't change it, it's strange, b'z multiple tutorial I used don't mention this. for them it work fine with default codepage (1252).
So I can't load 65001 page into 1252 db.. How to solve it? I tried to play AlwaysUseDeafuult param in dstx, not result, does it mean that I need to convert 65001 to 1252 with extra x-form box? I google it all and still can't see how to change to make it work:
Really appreciate your help, so "simple" thing is killing me...
Error at Data Flow Task [OLE DB Destination 1 [54]]: The column "Flat File Source Error Output Column" cannot be processed because more than one code page (65001 and 1252) are specified for it
Best
Mario
December 11, 2014 at 10:18 pm
Quick thought, looks like somewhere in the dataflow a column or set of columns are defined as unicode (65001), look out for DT_WSTR or DT_NTEXT in the column properties.
😎
December 12, 2014 at 11:20 am
Thanks, SS
Below is the only column in the whole dstx which has CodePage = 65001, DataType = TextStream[DT_TEXT]:
Flat File Source Error Output
_Output Columns
___Flat file Source Error Output Column
FlatFile.txt is saved as ASCII, other Column in Error output has CodePage empty and faded.
ANd most important: I tried to recreate this case on other pc/server and it works fine, that field on new Server has 1252 codePage, so I assume its' something about my local installation.
Best
Mario
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply