April 7, 2009 at 11:33 am
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.
April 7, 2009 at 12:08 pm
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
April 7, 2009 at 1:02 pm
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.
April 7, 2009 at 4:08 pm
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
April 7, 2009 at 9:11 pm
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