Post reply

Running/triggering/kicking off a SP in a DTS package

  • March 12, 2009 at 6:41 pm

    #202261

    I think the subject line says it all.

    I have a DTS package which runs a series of other DTS packages but I am hoping this can also run two Stored procedures as well.

    I can't see which object to drag in and amend in ordre to do this, if indeed it is possible.

    So, if indeed possible can someone point me in the right direction ?

    Thanks in advance,

    Mitch....

  • March 13, 2009 at 2:39 pm

    #959458

    Execute T-SQL task. Put the sproc name in there.

  • March 16, 2009 at 9:00 am

    #960299

    Cheers Steve, I did just that.

    It was asking for a connection so I placed the Connection object in there but could not link it to any of the other objects like I see in my other DTS packages that were created using the Wizard. However it works just fine having the Connection object just sit there in the package on its own and it does exactly as I had hoped.

    Thanks again.

  • March 16, 2009 at 9:13 am

    #960317

    you are welcome and thanks for the update. Glad it worked for you.

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

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