Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQL_SSIS_Dev
Starting Member
10 Posts |
 Posted - 2014-12-05 : 11:46:51
|
| 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 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-12-05 : 11:59:01
|
| You could wrap your file processing in a ForEachFile container. |
 |
|
|
mgreen84
Yak Posting Veteran
94 Posts |
Posted - 2014-12-08 : 15:55:03
|
| Could use the file watcher task also, but that may change you job setup. You could have the job run like every 60sec, or every 5mins. |
|
|
|
|
|
|
how to run SSIS pkge when input file doesn't exist