SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Header Row Delimiter Ignored in SSIS


Header Row Delimiter Ignored in SSIS

Author
Message
brdudley
brdudley
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1685 Visits: 1755
I'm dealing with a file where the header row is different that the rows in the body, in that it does not end in a delimiter. This is probably a bug and will be resolved, but it uncovered a behavior that seems to imply that the Header Row delimiter parameter is being ignored. I've tested with 2008 R2 and 2012, both show a problem, but they are not consistent with each other.

Consider a file:

One|Two|Three
1|1|1|
2|2|2|
3|3|3|

Set up a Flat file connection as a delimited file with Column names in first row, Header Row delimiter is {CR}{LF}, Column Delimiter is {|}, and Row Delimiter is {CR}{LF}.

In 2008 R2, the last column will include the pipe, i.e. 1|, 2|. In 2012 it does not!

My guess was to change the Row Delimiter to |{CR}{LF}. Both 2008 R2 and 2012 now treat the first two rows as header and add more columns, but they do not process the rows consistently. 2012 gives 2 rows with data in the first 3 columns, but 2008 R2 gives a single row.

Similarly, when writing files, it seems like the Header Row delimiter is not used.

Can anyone confirm or explain this behavior? Is this a bug or by design.

If I really need a difference, I can code around it. Mostly want to understand the behavior.

Thanks!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search