|
Home > Archive > MS SQL Server DTS > September 2005 > How to stop the Dts going to the next step.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to stop the Dts going to the next step.
|
|
|
| The idea is to have the first step to check a table for a value. If there
is a value then it will proceed to the next step, if there is no value found
the package will not continue. As I am not a programmer by nature, could
someone assist with some ideas or sample. I would think it would sample but
it is not clicking for me what to return to cause it to halt.
| |
| Darren Green 2005-09-21, 9:24 am |
| You would use workflow to gracefully halt a package. Instead of checking the
file as in the example below, use an Exec SQL Task to query the table and
return the result to a global variable, using the Parameters support in the
task. Then test the global variable.
How can I check if a file exists?
(http://www.sqldts.com/default.aspx?211)
--
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"CD" <mcdye1@hotmail.REMOVETHIS.com> wrote in message
news:umBpHsqvFHA.3588@tk2msftngp13.phx.gbl...
> The idea is to have the first step to check a table for a value. If there
> is a value then it will proceed to the next step, if there is no value
> found the package will not continue. As I am not a programmer by nature,
> could someone assist with some ideas or sample. I would think it would
> sample but it is not clicking for me what to return to cause it to halt.
>
|
|
|
|
|