CODEWITHSUNDEEP
sql-serverexcelssis
Roshan
Roshan

Reputation: 3384

How to remove total row and group header from excel sheet using SSIS?

I am new to SSIS. I have a excel file which contains grouped data, grouped by supplier as follows 

Group header line
Detail lines1
Detail lines2
Detail lines3
Group footer with totals

Is there any method to remove these Group header and Group footer using SSIS?

Upvotes: 1

Views: 215

Answers (1)

john McTighe
john McTighe

Reputation: 1181

You can select a range from Excel:

EG

If you have Sheet1:

head    
Name    Amt
John    1
Bob     2
Fred    3
Foot    


select * from [Sheet1$A2:B5]

This will give the detail & skip the header.

Upvotes: 1

Related Questions