Solved

SSIS Exit/Stop Package

Posted on 2012-03-19
3
1,202 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel conversion issue with Sql server 14 47
Distributed Replay - When should i use it? 1 24
TSQL previous 5 24
sql query questions 2 21
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

920 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

13 Experts available now in Live!

Get 1:1 Help Now