How do I run data flow task successfully if certain files in the data flow doesn't exist

Question

I have a data flow task that imports excel files. I cant use a for each loop to go through the excel files as the metadata for each excel file is completely different.

So in the data flow task I have 10 separate source files and use a union component to combine them then import it to SQL.

Problem i am facing now is sometimes certain excel files that i am importing might not exist so when my package runs it will fail as the file doesn't exist. So is there any way for me to create a check that allows the package run to skip the source file that doesn't exist and run the rest of the source files?

I am using SSIS 2005.

John Saunders John Saunders · Accepted Answer · 2012-10-19T20:08:00

Suggestion: if the file doesn't exist, then create it first.

Have an empty version of each source file somewhere, and in your control flow (before the data flow), check to see if the files exist, and if they don't, copy the blank files to the location of the real files.

How do I run data flow task successfully if certain files in the data flow doesn't exist

2 Answers