Is there a way I can change the connection properties
(Server Name, DB Name etc) dynamically. Basically I have a
Table consisting of Server Name, DB Name, user name and
pwd fields. I have a DTS job that should be able to read
each record from this table and change the connection
properties to the respective values and run the job on the
corresponding server?

Thanks in advance,

Narendra

Yes check these out

Connections
(http://www.sqldts.com/default.aspx?101)

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Narendra" <nnarendra (AT) yahoo (DOT) com> wrote

Allan,

Thanks, I think similar problem is addressed here. If at
all I need further help I might come back here.

Thanks,

Narendra.