Running packages from VBscript

  • Not being a DTS kinda guy, if you always would run ABC, why not build that into package A? A simple way to do what you're asking is to have each package set a flag (row in a table, disk file, whatever), then in your app you wait for that flag to be set before you continue execution.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • Thanks Andy for you help.

    I do appreciate that.

    Lou

  • Another I idea that I have grown to love is actually not calling the packages from the page but from a Stored Proc.

    I find it is much easier to call one proc and have it do your bidding from within SQL.

    I can muster up a link if needed

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

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