Post reply

Import Standard Set Of Maintenace Plans From BIDS SSIS

  • December 22, 2010 at 5:17 am

    #144513

    I have created a standard set of SQL2K5 maintenance plans and then added them to a BIDS SSIS package. This then allows me to change where the local server connection string points to. I can then import these .dtsx files onto each SQL 2005 server knowing the packages are pointing at the correct local server connection! However, if there are two instances running on the same server, I can't seem to figure out how to import two different sets of packages. As SSIS is a shared service, it just overwrites what's already there, thus breaking the original set of imported packages.

    Is there a way around this?

    Thanks

    Steve

  • December 22, 2010 at 6:16 am

    #1265466

    However, if there are two instances running on the same server, I can't seem to figure out how to import two different sets of packages.

    You need to edit the <ServerName> property in C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml. The Instance name for SSIS is stored in this file.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • December 22, 2010 at 6:58 am

    #1265493

    Great - thanks.

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

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