Hello Owais Bashir Ahmed,
Thanks for this interesting Article!
I would like to add that you don't have to use the version ID when calling DTS Packages from within DTS Packages. Instead you can refer by name only.
Personally, I prefer the following approach regarding the deployment of DTS packages:
Each DTS Project requires a custom deployment package which has the following characteristics:
- Adjust Connection details like Server Name / Database Name / Username / Password
- Adjust other details like LogServerName or LogFolder
- Adjust custom DTS settings like a RetryCount, disabling a certain step, or just any other global variable.
The main difference is that there is no global deployment package for all DTS projects, since packages are usually not very similar and need different customizations. And what you are trying to avoid when moving a package is that you miss out that one important setting somewhere in one of the packages.
I also prefer to have a UI for the DBAs where they can adjust all relevant settings to simplify the installation for them.