Jason Marshall
SSCommitted
Points: 1791
More actions
August 26, 2009 at 8:58 am
#135074
Good morning-
We have a file for import that has the header on every new page. What is the best way to skip the header rows that occur after the first one?
Tim Mitchell
SSCoach
Points: 15681
August 26, 2009 at 9:07 am
#1044943
If there is a predictable pattern to the data within the header record, you could use a conditional split transformation and send those header rows to an alternate location.
hth,
Tim
Tim Mitchell, Microsoft Data Platform MVPData Warehouse and ETL ConsultantTimMitchell.net | @Tim_Mitchell | Tyleris.comETL Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply