Excel imports

[ZenRaven]

I'm attempting to create an SSIS package that will import several excel files into a sindle table. I'm using openfiledialog in a script task to prompt user to select multiple excel files and then storing the array in an SSIS object variable. I'll then use foreach to process each file (have yet to tackle foreach loops).

The problem I have is that I want to check the header of each excel file to make sure the columns are always the same and kick back an error if they are not.

I tried using a sql task to pull the 1st row from the file and check each column but it seems extremely cumbersome and not very flexible.

Any suggestions?

Thanks

 

[MDXer]

you are probably going to have to write a custom script task to do this.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck