Solved

SSIS Exit/Stop Package

Posted on 2012-03-19
3
1,185 Views
Last Modified: 2012-03-20
I am using a script task manager that removes a password from a file, then processes the file.
what i want to do is exit the package if the file or the folder does not exist.

i have tried             Dts.TaskResult = ScriptResults.Failure
but the rest of the package continues to run.


Thanks.
0
Comment
Question by:aneilg
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
brad2575 earned 500 total points
ID: 37737370
You can build an if logic in your flow, if you double click on the flow line from the file check/import to the rest of the work, there is IF Success, if variable == value, etc, then proceed, if not do something else (follow other flow).
0
 

Author Comment

by:aneilg
ID: 37737577
cool thanks, i was think too much about the problem.
0
 

Author Closing Comment

by:aneilg
ID: 37741711
cool, thanks.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now