FileSystem Deployment

I am still a little confused on how the file system deployment works. When I deploy my files they end up in {ROOT}/Microsoft SQL Server\90\DTS\Packages\{PKGBUNDLE}, but the connection managers still reference the original dev path. Why does it copy to a seperate directory but still reference the old path, what's the significance? Is using pkg_vars the only way to update conn mgrs to reflect the new path? (outside of using a grep util to search and replace)

I guess I am looking for design patterns, how are others handling the deployment process when deploying on the same server?

P.S. When we port this to the production server, we plan on using the same directories and steps as in staging...What you are probably after is configurations. These are designed such that you store all of the parameters which change between deployments in a configuration, or related store, and just pass the correct configuration into the package each time you use it. The location of the configuration is what may change, but the way you specify this would be chosen such that is common accross all machines.

The package storage location has no bearing on connections and neither should it. Just because my packages move the connection location an still be teh same, teh same SQL server, the same smpt server, and the same file path, if local to a machine or if using a UNC path, they can still all be the same. File system deployment vs any other deployment is just about the storage location really, not the package internals and settings.|||

Yah, I understand your point, I was more so wondering if I could have a seperate custom stored location other then under the default SQl Server\90\DTS....

|||Sorry, I get you. Not sure if it is supported, but playing with MsDtsSrvr.ini.xml may be what you want C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml

Some related links-

SSIS and SQL Server Instances
(http://www.sqlis.com/default.aspx?57)

Modification of MsDTSSrvr.ini.xml does not work in June CTP - Microsoft Technical Forums - It does work, see post.
(http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=61179)

Try a BOL search for that file as well.