Determining Excel spreadsheet format before Data Flow Task
Posted
by
Josh Larsen
on Stack Overflow
See other posts from Stack Overflow
or by Josh Larsen
Published on 2012-12-12T21:41:12Z
Indexed on
2012/12/12
23:03 UTC
Read the original article
Hit count: 207
ssis
|ssis-data-transformations
I'm working on an SSIS package which uses a for each loop to iterate through excel files in a directory and a data flow task to import them.
The issue I'm having is that the project manager I'm working with doesn't think the users will always follow the structure. So if a file is in the folder and the package tries to import it but the spreadsheet is missing columns or has extra columns it generates and error of course. Even though I have the task set to not fail the package; the package does indeed fail and then the other files aren't imported.
So, I'm wondering what is the easiest way to either determine the spreadsheet is incorrectly formatted, or stop the error from failing the package execution? After taking said step I would just use a file copy task to move the file to a "Failure" folder. Then continue on processing the spreadsheets.
© Stack Overflow or respective owner