Import data from .xls to table by removing unwanted columns?

Asked Feb 26 '14 at 19:32

Active Feb 26 '14 at 19:32

Viewed 43 times

I am creating a SSIS package to import data from .xls(EXCEL sheet 97-2003) to Sql DB.But my .xls file consists of unwanted data for first 4 rows .How can i skip those data. My file look like

Create by:
Modified By:
Date:
Team:
Id     value      sum
1       44         88
2       45         98

I tried by i havent seen any advanced option in excel source to skip the rows as we do for .cs file.Can you please guys help me??

asked Feb 26 '14 at 19:32

user3203331

Do you have access to the file? Can you delete those rows? The metadata will look at the first row for column headers (if the option is selected on the Excel Source) – TTeeple Feb 26 '14 at 19:36
Why not make a copy of your xls and remove the four lines? – Doc Brown Feb 26 '14 at 19:36
1

@TTeeple:I cant do it daily because SSIS package dynamically want to do job every day morning. – user3203331 Feb 26 '14 at 19:42
you can skiip the row once the data is in SSIS pipeline using conditional filter. – Anup Shah Feb 26 '14 at 19:47
See my answer here: http://stackoverflow.com/questions/4929217/openrowset-for-excel-can-we-skip-several-rows/8903076#8903076 – Anon Feb 26 '14 at 20:03
@Anon:I got your answer ,where i need to use that Query to skip rows? – user3203331 Feb 26 '14 at 20:10

Import data from .xls to table by removing unwanted columns?

0 Answers0