February 2, 2009 at 10:35 am
Hi there,
I use a foreach loop container to go through a number of excel files.
Not all the excel files have the same structure and I only need to load the files with a specific layout.
Is there any way to test the structure before reading the excel file or ignore the "wrong" excel files ?
February 2, 2009 at 5:49 pm
Maarten Ter Laak - your question is overly broad in its scope. Would it be possible to post a short (a few rows along with column headers if they are used) of a Excel file that should be processed, and one for an Excel file that should not be processed? Please be sure to specifically list the item(s) upon which the process / not processed decision is based. With that information hopefully someone here will be able to assist you.
February 2, 2009 at 10:16 pm
The excel files I want to process holds dates on the columns and a number on the rows.
I unpivot these which works fine. Other excel files in the directory can be anything.
I want SSIS to ignore the file which does not validate and proceed with the next.
Presently I remove all files I do not want to process manually.
February 3, 2009 at 5:25 am
If you can get just a bit more specific, I think we can help you.
What do you mean by 'validate'? Is there a certain column that always has a certain name in the files which you want to process? What you need to think of is a simple yes/no test (or tests) which can be performed - ideally on the field names or on the number of fields in the Excel sheet.
Phil
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply