March 18, 2011 at 4:29 am
Hi All,
I am having chinese traditional data as source file in SSIS.
I have taken CODEPAGE 950.
Source file is | delimited and in the data containes | symbol as double byte data.
When I previewed data even | symbol is there in the data it is not splitting the single column in to multiple columns depending on | symbol.
WHY THE DIFFERENCE B/N DESIGN MODE AND RUN MODE.
How can I come out from this issue
Regards
March 18, 2011 at 10:01 am
Without seeing your file and all properties of your flat-file connection object it's hard to say, but I'll take a shot at it providing some background info:
SSIS does not support embedded column-delimiters by doubling the delimiter.
For example this line where the column-delimiter is | and text qualifiers are <none> will be processed as 4 columns, not 2:
1|2||4
If you need to support embedded row-delimiters you'll need to have your file formatted like this and have the text qualifier set to double-quote:
1|"2|4"
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 20, 2011 at 10:18 pm
Hi,
Thanks For reply.
The client is not interested to provide text qualifier and he is not interesed to change the file format.
My question is in design mode previewer the data is showing correctely.
But in run mode only one column data is splitting into multiple columns.
in design mode previwer
Column1 1
column2 2|4
column3
Runmode
Column1 1
column2 2
column3 4
Code page is 950.
and data type is DT_WSTR
Delimiter |
these are the properties.
Regards
March 21, 2011 at 7:04 am
Using the example Column data you gave what does the actual line of text look like in the file? 1|2||4|3 ?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply