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 |
|
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. |
 |
|
|
|
|
|
SSIS flat file exists -- do not fail when file doe