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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 how to run SSIS pkge when input file doesn't exist

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.
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -