SSIS default installation path

  • I've overcome any number of obstacles creating my first SSIS package. The last one (hopefully) I find answers for, but those answers don't give the intended response.

    I want to to permanently change the default installation folder from C:\Program Files\Microsoft SQL Server\90\DTS\Packages to D:\SSISPackage, so that when the package is rolled out to other servers there is one less thing to worry about. I've modified the MsDtsSrvr.ini.xml file so the StorePath line now reads . I restarted the Integration Services service, then went through the Package Installation Wizard using the SSISDeploymentManifest. After the install, the default installation folder received the package, not D:\SSISPackage.

    If someone can tell me what I'm missing I would appreciate it.

  • It is like SSRS you must install it in your C drive because the installation path is fixed which means you cannot change the location. Check below for details.

    http://msdn.microsoft.com/en-us/library/ms143547(SQL.90).aspx

    Kind regards,
    Gift Peddie

  • I'm not looking to change the location that Integration Services gets installed to, I'm looking to change the default folder a given SSIS package gets deployed to. In theory it works, in (my) practice, not so much.

  • I think you need the DtUtil utility it lets you specify path including UNC, check below for details.

    http://msdn.microsoft.com/en-us/library/ms162820.aspx

    Kind regards,
    Gift Peddie

  • If you make your packages location-unaware, you can just Xopy them wherever you want.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

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

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