Possible to call a package from a SP ?

  • Hi,

    Is it possible to call a package from a SP ?

    Maybe it s stupid and better to code everything in the SP... but i would like to know

    THANKS

    Oliver

     

     

  • it is.  Look at DTSRun in BOL



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  •  use the following statement in the stored procedure

    exec dtsrun /S<servername> /U<username> /P<password> /N<packagename>

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

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