about package exe status - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

about package exe status

Author

Topic

dasu
Posting Yak Master

104 Posts

Posted - 2004-10-28 : 09:34:29

i have two packages
p1
p2
iam calling p1 in p2
my require ment is if p1 fails then it exits from
p2 also.
please suggest me the solution
regards
dasu.g

surefooted
Posting Yak Master

188 Posts

Posted - 2004-10-28 : 10:41:10

Set failonerror to 1 in the disconnect edit of p2

-Jon
Should still be a "Starting Member"

dasu
Posting Yak Master

104 Posts

Posted - 2004-10-28 : 10:51:25

i did not find such option in disconnect edit ->execpackage task
please tell me where we can get this

failonerror
regards
dasu.g

surefooted
Posting Yak Master

188 Posts

Posted - 2004-10-28 : 11:13:39

the parent package, go to Package\Disconect Edit\property name\fialonerror

-Jon
Should still be a "Starting Member"

dasu
Posting Yak Master

104 Posts

Posted - 2004-10-28 : 23:09:45

i find this options
pacakge -> disconnected edit->steps->failpackageon error(boolean)
is it correct
if i made above option to -1 then also it is not exit from main package

please suggest me the proper solution
regards
dasu.g

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-28 : 23:16:05

Just use an on success connector when you do the call to the other package. So if the previous step doesn't success, then this package will never get execute since on success isn't true.

Tara

dasu
Posting Yak Master

104 Posts

Posted - 2004-10-29 : 02:01:28

PLESE I WILL GIVE CLEAR PICTURE ABOUT MY TSK

P1 PACKAGE
P2 PACKAGE

OPEN
P1 PACKAGE
IF ANY ERROR IN P1 PACKAGE
THEN CALL P2 PACKAGE
IF ANY ERROR IN P2 PACKAGE EXIT FROM P2 PACKAGE
AND IN P1 PACKAGE U HAVE TO EXECUTE FAILURE FLOW
THIS IS MY TASK
PLEASE SUGGEST ME THE SOLUTION
REGARDS
DASU.G

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-10-29 : 03:10:03

quote:
Originally posted by dasu

PLESE I WILL GIVE CLEAR PICTURE ABOUT MY TSK

P1 PACKAGE
P2 PACKAGE

OPEN
P1 PACKAGE
IF ANY ERROR IN P1 PACKAGE
THEN CALL P2 PACKAGE
IF ANY ERROR IN P2 PACKAGE EXIT FROM P2 PACKAGE
AND IN P1 PACKAGE U HAVE TO EXECUTE FAILURE FLOW
THIS IS MY TASK
PLEASE SUGGEST ME THE SOLUTION
REGARDS
DASU.G

i think you got the solution, just implement it, use workflow as Tara had suggested.

--------------------
keeping it simple...

dasu
Posting Yak Master

104 Posts

Posted - 2004-10-29 : 04:01:21

please explain it clearly
i did not understand the solution which tara suggested

dasu
Posting Yak Master

104 Posts

Posted - 2004-10-29 : 06:51:46

i got some solution for this

p1 package
p2 package

in p1 pakcage
if any err occured just iam calling p2 package
if p2 pakcage has some error immidiately it exits from the task which error occured with out executing error flow.
but acording to my task it has to execute some error flow tasks there
and it exits from p2 package and it has to follow error flow and do some error handling in main package also.

please
suggest me proper solution

surefooted
Posting Yak Master

188 Posts

Posted - 2004-10-29 : 09:14:54

Wait, we aren't understanding you clearly. I thought you were calling a package from within a package, hense I sugested the disconnect edit, but if they are in the same package (i.e exec 1 -> 2) then use the workflow properties as Tara said above.

Click pakcage 1, hold ctrl or shift, then click package 2. Select workflow from the menu drop down and select on failure. This will cause package 2 to run when package 1 errors.

-Jon
Should still be a "Starting Member"

surefooted
Posting Yak Master

188 Posts

Posted - 2004-10-29 : 09:17:35

If you want a package to fail itself without error flow, you need to set the disconnect edit property in that package.

-Jon
Should still be a "Starting Member"

dasu
Posting Yak Master

104 Posts

Posted - 2004-11-02 : 03:19:30

i got the solution like this can i use this

initially i made failOnError for inner package set to 0
i did all the stuff
at end of inner package task i modify failOnError to -1
so it exits from inner package immidiately with failure status.
i am using this aproach.
please tell me any side agffects with that.
regards
dasu.g

dasu
Posting Yak Master

104 Posts

Posted - 2004-11-02 : 07:22:42

my requirement is like this

i have two pakages
1.inner
2.outer

my flow is like this

if error occured in outer package
then
in err handling work flow ,iam calling inner package.
if error occured in inner package it has to do some error handling
work flow
and it returns failure status to outer package.
in outer package it has to do
some error handling work flow for that execute package task fail.
this is my require ment

outer--failure-calls---->inner-----failure--errhandling for failure
return status failure------->outer package--------failure------->errro
handling for outer package.

iam achieving that by following way

in inner package at initial task i made failOnError to set 0
i am doing error handling work flow
at end i made failOnError to -1
so it exits from the task

so my question is can i use like this operation?

if not suggest me the other solution for this
regards
dasu.g

surefooted
Posting Yak Master

188 Posts

Posted - 2004-11-02 : 08:08:58

Test it. If it works for you then sure.

-Jon
Should still be a "Starting Member"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources