I'm running multiple instances(developpement,acceptation, production) on one server with the same db's on each one of them.
Now I'm trying to find out a way to transfer DTS packages from one instance to another (I know it is straight-forward if you don't have to change anything) but in my case I would want to change the connection properties within the dts package e.g.
on my server\developpement instance I've created a DTS package with connection properties server name server\developpement
Now I want to transfer it to my server\acceptation instance and there I want the connection properties server name to be server\acceptation .
I've tried doing it with a dynamic properties task but I can't seem to find the instance name where the package is saved. I can only find the server name(environment variable).
This of course is no problem if you have but a few packages, but if you have over 50 to transfer
Any help would be more than welcome.
PS: I know it is possible between two different servers using (local) as the servername but that's not an option for my boss.