 | |
ActiveXScript Exit Gracefully when file not found?
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
ActiveXScript Exit Gracefully when file not found? -
11-10-2005
, 12:55 PM
#2
| |||
| |||
|
|
If a file to import is not found I'd like to set the status to something other than Success or Failure? Id like to be able to branch to an error handler that will just exit the Pk gracefully. Or, perhaps there is a way to skip other steps? TIA JeffP.... |
#3
| |||
| |||
|
|
Jeff, I found this article very helpful in determining if file exists or not and also what to do next... http://www.sqldts.com/default.aspx?211 Regards, Alex, "JDP@Work" wrote: If a file to import is not found I'd like to set the status to something other than Success or Failure? Id like to be able to branch to an error handler that will just exit the Pk gracefully. Or, perhaps there is a way to skip other steps? TIA JeffP.... |
#4
| |||
| |||
|
|
Alex, Thanks, I found the same article in this NG, but I posted it to my prev. related Q. JeffP.... "Alex Prints" <AlexPrints (AT) discussions (DOT) microsoft.com> wrote in message news:6892F258-779E-4A0A-9192-56327EE1F834 (AT) microsoft (DOT) com... Jeff, I found this article very helpful in determining if file exists or not and also what to do next... http://www.sqldts.com/default.aspx?211 Regards, Alex, "JDP@Work" wrote: If a file to import is not found I'd like to set the status to something other than Success or Failure? Id like to be able to branch to an error handler that will just exit the Pk gracefully. Or, perhaps there is a way to skip other steps? TIA JeffP.... |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.