How to Conditioanlly Force Package to Exit ?

[JohnBates]

good morning,

This is SQL Server 2000.

Within an ActiveX Script Task, I check for a text file's existence. If the file is found, I want to continue executing at the next task.

But if the file is NOT found....
- I want to perform some steps, then stop execution altogether.

I suppose this can be done by changing the ActiveX Script Task's Workflow properties, but I'm not sure how to do that, within the code.

Thanks for any help.
John

 

[Glowworm27]

Follow this link

http://www.sqldts.com/default.aspx?6,103,246,0,1

It explains looping though files using dts package

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net