how to make my SSIS package execute successfully, even when there is no input feed file.

[SQLSSISDev]

Hello,

Currently I am running a SSIS package scheduled daily at 7 A.M. It expects two feed files from two different folders.

The first step in my package will rename the input files in those folders to names which the package can understand. I have created two variables in my package to read the files with those file names. I used these variables in connection managers.

If any of these folders doesn't have input files when the package runs, the package will fail. Can someone please let me know how to make the package the run successfully even there is no input feed?

Any help is highly appreciated.

Thank you.

 

[fredericofonseca]

you better off creating a script task on your package and check for the existence of the required files using the filesystem io classes

this would do all the moves you require and set variables accordingly which can then be used to control the remaining flow of the package

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[gk53]

it is common task set variable something doWeRun and default value N.
your first task should be script task which using vb or c# check if both file exist and if yes change value on doWeRun variable to Y
on connection to next task change constraint options to "Expression and Constraint" and add a condition @[doWeRun] == Y
and it is all what you need