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 2008 Forums
 SSIS and Import/Export (2008)
 SSIS flat file exists -- do not fail when file doe

Author  Topic 

skyline01
Starting Member

1 Post

Posted - 2014-12-16 : 13:14:50
I am working in SSIS (BIDS) under SQL Server 2008 R2. I have a package that imports a flat file to an OLE DB. I first test if the file exists via a script task before it moves to the data flow task. On the precedence constraint between the script task and the data flow task, I have it configured to Evaluation Operation = Constraint, and Value = Success. I also need a path to follow if the file doesn't exist. If the file doesn't exist, I don't want the SSIS package to fail. I simply want nothing to be done (e.g., no import, no output message). I'm sure I need to add an another precedence constraint off of the script task (for the Failure event), but I don't know what to do after that. How do I achieve this?

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-12-17 : 11:19:13
add a precedence for failure of the file check task then do what you want.
Go to Top of Page
   

- Advertisement -