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
"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:
>
> > 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 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,
> > > > 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