Post reply

? using dtsrun utility

  • May 20, 2005 at 9:07 am

    #61137

    Does anyone know if using the '.' to specify the package to run on the local server takes multiple SQL Server instances into account?

    I want to run the following on a multiple instance server but didn't know if it will pick the correct instance.

    dtsrun /S. /E /N<PackageName>

     

    Thanks

    Erich

  • May 20, 2005 at 10:28 am

    #560278

    Erich,

    when specifying the server (/S) use this syntax:

    /S server_name\instance_name

  • May 20, 2005 at 10:31 am

    #560281

    Thanks for the help, but I am trying to improve portability by not having to specify the server_name by using the /S and '.'

    I am trying to get to a point I can script out a job and runt the same script for test staging and production.

     

    Thanks Again

  • May 20, 2005 at 10:50 am

    #560288

    Another option would be to read through the registry and locate the instance names (along with the server name). This info could then be pumped into the DTSRun command.

    Good luck,

    Darrell

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

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