I am using SSIS to populate a table from excel. The issue is, at the bottom of the excel sheet there’s some summary information that is not needed and in a different structure to the rest of the spreadsheet, as a result of this when I run my package I get an error.
I have tried creating a script component but can quite get it to work.
The rows are not static. This week I had 1543 rows last week I had 987 rows.
ABC123456 21/10/2014 Text Text 1 32 15/12/2014 7677787 1
Everything after here can be deleted.
Then there is a blank row.
Then 4 columns
‘Type’ ‘Events Exams’ ‘Text’ ‘Text’
A 10 10 0
Again the row count changes each week.
Then this is repeated two more times with slightly different columns and fields.
What I am trying to do is delete everything after my first set of data.