Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determine if Package failed or success

Status
Not open for further replies.
awolff02

awolff02

Programmer
Nov 24, 2008
6
US
Hi. I am confused.

I have an ActiveX task (TaskA) that does stuff.

At the end of the script I set the variable:

Code: 
Main = DTSTaskExecResult_Success
-or-
Code: 
Main = DTSTaskExecResult_Failure

What code do I need in the parent package to determine whether the TaskA was Success or Failure?

I guess I am also confused as to the difference between a Task and a Step? Can a task have multiple steps? or vice versa?

TIA-

Alex
 
Sort by date Sort by votes
I believe what your talking about is called "Precedence Constraints". For more information you can read about them in "Books Online" (BOL) which is the help file for SQL Server. Search for "DTS Package Workflow" and "Using ActiveX Scripts in a DTS Workflow" which should give you a basic understanding of how this works.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

betachristopher
  • Locked
  • Question
Use IF/ELSE in Query 1
Replies
3
Views
518
drlex
drlex
arodri
  • Locked
  • Question
MSVisual Studio - DTSX Package creating new text file
Replies
0
Views
447
arodri
arodri
HoustonGuy
  • Locked
  • Question
CPU usage of a package using tables on another server
Replies
0
Views
188
HoustonGuy
HoustonGuy
ashleybyrdnc
  • Locked
  • Question
DTS Package Failing
Replies
1
Views
246
mrdenny
mrdenny
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
429
botatun
botatun

Part and Inventory Search

Sponsor

Back
Top