Hello all,
Is it possible to have two different formats for the header and the data in a flat file connection?
An example text file would look like this:
Col1,Col2,Col3
abcdefghi12345testtesttesttest
abcdeeeee12333setsetsetsetsets
where the header is delimited and the data is ragged right.
It looks like you should be able to accomplish this from the Flat File Connection Manager Editor interface, but perhaps having different delimiter dropdown boxes for the header and columns can only be used if you are using the Delimited format?
Thanks for any info you can provide!
Jessica
Do you even need the header?|||No, but it would save a lot of time if we didn't have to type in hundreds of column names 
I was more interested in knowing if this functionality is supposed to work and I'm missing some check box... or if it isn't supposed to work.
|||I don't think this is supported currently.
No comments:
Post a Comment