any suggestions on dealing with a flat file in the format below. I only want to process the data columns in the middle of the file and want to ignore all other rows. This was a very simple task in DTS with a small amount of VBScript in the transformation but it doesn't seem as straightforward in SSIS. thanks
......... file example ......
start-of-file
header1
header2
...
start-of-data
col0|col1|col2|col3|....
col0|col1|col2|col3|....
col0|col1|col2|col3|....
end-of-data
end-of-file
Two steps.Read the file in first as one big text string (for each row) and pass them through a Conditional Split transformation to filter off each row that you don't want. Then hook it to a flat file destination.
Then use another flat file source against the file just created to do your column parsing. Work with it as needed from there.
Searching this forum will also yield other options (substrings, etc...) that you can try.|||thanks phil. thats helps
没有评论:
发表评论