Post reply

adding dt packages and stored procedures as steps in a job

  • July 13, 2005 at 7:54 am

    #164318

    i have two dts packages that run daily and a stored procedure. i would like to add these three as steps in one job, so that the two packages run one after the other and then the stored proc runs once these two have reported success.

    how do i  do this. using book online, i know that  i can use the operating system command option, and that the command is DTSRUN

    but i dont know what else needs to be done after that. is there an example or a source that i can go to to get this info

    [font="Comic Sans MS"][/font]It is what it is.

  • July 13, 2005 at 7:59 am

    #573897

    You can use the wizards of the jobs for that. Just add the 2 dts packages as the first steps, then the proc. It's all wizard and well explain. Message back if you need more help.

  • July 13, 2005 at 2:12 pm

    #574116

    Use the command line utility dtsrunui to generate the DTSRUN command with parameters.

    I won't give you the details because Phill Carter gives a good explanation of how to use it in this thread:

    http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=199161

    Greg

    Greg

  • July 13, 2005 at 9:48 pm

    #574244

    Looking at the GUI angle....

    Create another package .....call it Main

    In the main package:

    call package1 --> call package2 --> on success call store proc (sql task).

  • July 13, 2005 at 9:50 pm

    #574245

    Isn't it what I proposed?

  • July 13, 2005 at 9:53 pm

    #574246

    Oops...sorry

  • July 13, 2005 at 10:05 pm

    #574248

    No I thaught that it was another way .

  • July 14, 2005 at 5:00 am

    #574300

    Thanks all. i will try that. i hope it works. i will keep y'all posted.

    [font="Comic Sans MS"][/font]It is what it is.

Viewing 8 posts - 1 through 7 (of 7 total)

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