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
Norbert

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






"Norbert Kessler" wrote:

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

"Charles Kangai" wrote:

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



"Norbert Kessler" wrote:

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

"Charles Kangai" wrote: