Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SSIS Exit/Stop Package

Posted on 2012-03-19
3
Medium Priority
?
1,302 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
brad2575 earned 2000 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 Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

618 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