Edit...  

Using SSIS 2010.

I know this question has been asked many times, but I can't find it in these forums.  I have multiple excel files that I'd like to process as source data.  the data starts on line 7.

I have found ways to process multiple excel files as source when the data starts on line 1 and ways to process a single excel file with data starting on line N, but never a solution to both problems.

I tried using an OLEDB source with an expression for the connection string and the SQL command text:

select * from [Sheet$A6:G]

where the data starts on line 6 and there are G columns of data.

Please feel free to point me to the proper answer if this has already been answered.

Many thanks!

Mark

• Edited by MuddyNM 17 hours 2 minutes ago

Hi Muddy,

There is no SSIS 2010

Do you mean the data can start on row 12 today and on row 123 tomorrow?

If so you need to 1st run a program or script (a Script Task perhaps can do, too) to discover where the data starts, then generate the proper expression to be consumed in SSIS, but doing all that already defeats the purpose of using SSIS (ETL), it becomes an application.

In general I do not suggest using Excel for data inter-exchange.