Stop DTS Package

#1

I have a DTS package which checks for files in a designated folder, and
imports the ones it wants.

However, if no files exist it just reports an error, and the package fails.

Although this is what I want, it is untidy. Can anybody suggest how I can
add workflow 'If no files exist, stop running the package, and report
success'..

Do I have to put in a dummy task (like execute select 'Hello world') and use
'On Failure' to point to that?

Thanks

Nick

#2

How can I check if a file exists?
(http://www.sqldts.com/default.aspx?211)

"NH" <NH (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a DTS package which checks for files in a designated folder, and
imports the ones it wants.

However, if no files exist it just reports an error, and the package
fails.

Although this is what I want, it is untidy. Can anybody suggest how I can
add workflow 'If no files exist, stop running the package, and report
success'..

Do I have to put in a dummy task (like execute select 'Hello world') and
use
'On Failure' to point to that?

Thanks

Nick

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Stop DTS Package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Stop DTS Package - 12-07-2005 , 06:09 AM

Re: Stop DTS Package - 12-07-2005 , 08:09 AM