sknox (3/31/2009)
There's also a tweak I would make .....
...
If System.IO.File.Exists(Dts.Variables("FlatFileConnection").Value.ToString) Then
Dts.TaskResult = ScriptResults.Success
Else
Dts.TaskResult = ScriptResults.Failure
End If
...
That's a real nice upgrade to any package. Seriously, most SSIS package run unattended, and anything we (as developers) can do to enhance the reliability of our packages -- and, reduce support calls at the same time! -- is a real good idea! Sometimes a line or two of addition code can eliminate a lot of trouble later on!