I want 10 packages to run in sequence. I was told the Execute Package Task
would do it but it looks like it can only call one other package.

I want it to call all 10 in order.

Am I missing something

Thanks,

LP

So have 10 Execute Package tasks in a row with precedence constraints between them.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"LP" <LP (AT) discussions (DOT) microsoft.com> wrote

On Fri, 11 Feb 2005 21:48:20 -0000, "Allan Mitchell"
<allan (AT) no-spam (DOT) sqldts.com> wrote:
Or a job with ten steps each running one package.

J.

Yesy a job to call them all. When I've created the new job it doesn't show
any of the steps that call a DTS package they are mostly dealing with
Replicatin.

Any thoughts.

"JRStern" wrote:

Use a CmdExec Job step type and DTSRUN (Build the synatx using DTSRUNUI)



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"LP" <LP (AT) discussions (DOT) microsoft.com> wrote

On Sun, 13 Feb 2005 17:11:26 -0000, "Allan Mitchell"
<allan (AT) no-spam (DOT) sqldts.com> wrote:
Or, click on the package, select "schedule this job", and it will
generate the job and the command line all encrypted for you.

J.