Post reply

Scheduling a Project rather than Packages in a sequence.

  • August 31, 2006 at 7:21 am

    #170011

    ----------------------

    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

  • September 4, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • November 17, 2006 at 1:07 am

    #672521

    You need to have a master package in each of the project. The master package will have all the package as Execute Package task in sequence. You can then schedule the master packages.

  • November 20, 2006 at 3:03 am

    #672884

    Thanks Kashif,

     

    I will keep that option available as i develop new packages.

    Currently however, I've set the individual packages within a project as individual steps in a a job.

    It kind of does what I need although there are some limitations when a package fails.

    Thank you

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply