Scheduling a Project rather than Packages in sequence. 2

[luzippu]

----------------------
MS Win XP Pro 2002 SP2
MS SQL Server 2005
MS Visual Studio 2005
----------------------
I have designed 3 Projects (.dtproj) in Visual Studio each containing a dozen Packages (.dtsx) and saved them on a local folder.

I'm now in Management Studio and would like to schedule these to run in a specific sequence.

1. Is it possible to schedule the whole Project rather than scheduling each individual Package?

2. What is the easyest option to run them in sequence (ie: run 'b.dtproj' when 'a.dtproj' is successefull, run 'c.dtproj' when 'b.dtproj' is successefull)?

Thank you guys

 

[manmaria]

1.I do not think you can schedule a project because the options available for schedule is not included a project. It has ActiveX Script,AS,IS,TSQL etc but not the project.

2.To run the packages in sequence, create a job with multiple steps and in the first step run "A" package and use the options as "on success to the next step" and "on failure quit the job reporting" then in the second step run B package and so on.

If you have a job J1 with multiple steps and job J2 with multiple steps then J1 and J2 can run in sequence by using the Service Broker but I do not have the details.

HTH

 

[mrdenny]

You can not schedule a project. SQL Server doesn't know what a project is. The projects are used to grouping things together for easy administration and development so that related packages can all be edited together.

You will need to setup a job step for each package to have them run in order.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com