(Type your message here)
I have setup a DTS package that has 2 package tasks setup to runone after another with the work process setup to do the nextpackage task only upon completion/success of the first packagetask. Each package task has a SQL job to be executed thatbasically executes a stored procedure. When I execute thepackage the first package task executes and the SQL job startsbut before the job completes the second package task is executedand its job also starts. So basically i have 2 jobs running andthe package has completed its full execution. How do I preventthis from happening?. I want the second package task to startonly after the first task(SQL job) completes successfully.
--------------------------------
From: Gurunathan Kandaswamy

-----------------------
Posted by a user from AdminLife (http://www.adminlife.com/)

<Id>GM0YzHwom0Kwh84UqjOSHg==</Id>

Why do you need 2 seperate packages to do this?
This, by the sounds of it, could be done in a single package

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Gurunathan Kandaswamy via AdminLife" <anonymous (AT) adminlife (DOT) com> wrote in
message news:ugVIvqPjEHA.2652 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
(Type your message here)
I have setup a DTS package that has 2 package tasks setup to run one after
another with the work process setup to do the next package task only upon
completion/success of the first package task. Each package task has a SQL
job to be executed that basically executes a stored procedure. When I
execute the package the first package task executes and the SQL job starts
but before the job completes the second package task is executed and its job
also starts. So basically i have 2 jobs running and the package has
completed its full execution. How do I prevent this from happening?. I want
the second package task to start only after the first task(SQL job)
completes successfully.
--------------------------------
From: Gurunathan Kandaswamy

-----------------------
Posted by a user from AdminLife (http://www.adminlife.com/)

<Id>GM0YzHwom0Kwh84UqjOSHg==</Id>