0

JDM : Excel Datasource skip first 4 records

Hi

In SSIS when reading excel files you had the option to skip the first couple X no of rows (maybe cause the header started at row 4 for instance) you could modify the "OpenRowSet" property for the datasource. 

Example = "Sheetname$A4:ML"

Is there an option like this in JDM or do I need to take a longer route by manually excluding the first redundant rows with a staging database data selection rule?

Thanks in advance

Alex

 

0 comments

Please sign in to leave a comment.