Dear All

I have arround 100 packages in all packages I have put IP of the server
in the connection.


Now I want to use all this package on other 2 servers.
So I need to change the IP in the connection for all this 100 packages.

Is there any easy way to do this?
I dont want to open each package and change IP for each connection.


Regards
Amish

Amish,

I am afraid it is time to redesign you packages to put that IP into a
variable and to add a Dynamic Properties task to assign the IP to all
connections. Otherwise you can develop a VB program to change IPs and save
the packages.

Ilya

"amish" <shahamishm (AT) gmail (DOT) com> wrote

Thanks Ilya
Can you provide me some sample how to put that IP into a
variable and to add a Dynamic Properties task to assign the IP to all
connections


Regards
Amish


*** Sent via Developersdex http://www.developersdex.com ***

Amish,

In the package properties dialog go to Global Variables tab and add a
variable. Assign the IP address to the variable. Add a new Dynamic
Properties task and using Add button navigate to each connection one by one
assigning the new global variable to the DataSource property. Make sure the
task runs before any task that requires connection.

Ilya

"AM" <anonymous (AT) devdex (DOT) com> wrote

A simple way of concealing IPs, and still resolving them is to use an alias,
see the Client Network Utility.
DNS would probably be better, but aliases are machine specific, and often
easier to control. This can work well when migrating packages between
environments.

For the same package to point to different places, yet using the same
instance of the package as opposed to migrating it, passing in the server
would make more sense however.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"amish" <shahamishm (AT) gmail (DOT) com> wrote

It worked
Thanks


*** Sent via Developersdex http://www.developersdex.com ***