Groups | Blog | Home
all groups > sql server dts > september 2006 >

sql server dts : Deploy SSIS to Sub-Folder in MSDB



Norbert Kessler
9/11/2006 4:06:02 AM
Hello,
we created a sub-folder structure within the msdb storage. Is there any
possibility to explain in the DTSDeploymentManifest or wherever that the
packages should deployed into a specific subfolder and not to the root?

thanks in advance
Charles Kangai
9/11/2006 9:08:01 AM
You should configure where you want the packages to go in the file
MsDtsSrvr.ini.xml which is located in the folder C:\Program Files\Microsoft
SQL Server\90\DTS\Binn. The default location is ..\Packages. You can change
it to, for examples, ..\Packages\MyOwnPackages.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk






[quoted text, click to view]
Norbert Kessler
9/11/2006 9:49:02 AM
Hello Charles,

thanks for this information. As far as I understood, ist this tag only used
for File Storage. Is the same tag (or a similar) usable for storing this in
the MSDB, too?

Regards
Norbert

[quoted text, click to view]
Charles Kangai
9/11/2006 10:08:02 AM
You are right. I didn't read your question correctly. The tag is only used
for File Storage. The folders in msdb are internal to the msdb database. You
will see that the storage in msdb.dbo.sysdtspackages90 table do not expose
the internal hierarchy.

Charles Kangai



[quoted text, click to view]
Norbert Kessler
9/14/2006 12:53:01 AM
There is a reference folderid in sysdtspackages90. I assume, that this
references to sysdtspackagefolders90. But I've no idea if I'm allowed to
change this folderid manually. The better way would be to define the folder
or folderid (Path) during the deployment in any way.

Norbert Kessler

[quoted text, click to view]
AddThis Social Bookmark Button