schedule the task

I want to schedule the task using contro panel schedule task item.

I want to run two package in sequence. If the execution of one gets over then other should start.

I have configured the execution detail in BAT file.

I know how to schedule the task. But can anyone please suggest me how to schedule the task in sqeuence i.e. execution of BAT file in sequenece (one after other).

I suggest that specifing job from sql server agent is the best way to execute sequeneced package|||

leo1 wrote:

I want to run two package in sequence. If the execution of one gets over then other should start.

Try the master package scenario mentioned here -

Run multiple SSIS packages in order - MSDN Forums
(http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=748282&SiteID=1)

|||

thanks for the reply.

But My packages are not dependent. and I want to use the windows schedule task.

I want to run it using the BAT file, PLease suggest me how to schedule it using windows scheudle task one after other

|||

"one after other" means dependent, in my understanding of English. If you are worried about packages failing, but still want to execute the subsequent package, then you can still use a master package with precedence constraints, as they can be evaluated for success, failure or completion.

If you want to use Windows Scheduler and a batch file, then do so. Are you asking how to call a package from a batch file? If so lookup DTEXEC in Books Online. Just add multiple calls to DTEXEC in the batch file.

Schedule DTS Packages to run sequentially

Hi,

I have eight DTS packages. I would like to schedule all of time to run every night. Can I do this in sequence like something similar to scheduling "Job" in SQL Server Agent, when package one finish, immediately execute package two, then package three...and so on.

Any ideas? Thanks in advance.

SnoopyCreate a job, each step in the job can be the next package.

Step1 = Package1
Step2 = Package2
ect.....|||SHICKS:
Thanks. Can you tell me how to do it? Can I do it through SQL Server Agent?
When I go to SQL Agent -> New Job -> steps -> New Job steps, I don't know where to specify my package. Or should I do in by other methods? Thanks in advance.|||If you are using SQL 2000 Client you can define a dts Package Run object at the end of each DTS Package.

SQL 7 CLient does not have this functionality