When I was changing databases and servers I was connecting to I set up a
dynamic properties task to set the connection as others have suggested
(either read from SQL Server table or ini file). In addition I had to
do a "disconnected edit" and change the table names for some of my
transformations. Some table names for the transformations were fully
qualified including database. I had to modify those to simply have
table name or owner.tablename. After that save the changes. If you
feel more confortable you can also use a dynamic property task to update
table names on the transformations to remove the database qualifier from
the table name.

Good luck.


Brian Freeman
Carnegie Technologies/Bluewave Computing
(770) 916-0595 ext. 415
www.carnegie.com
www.bluewave-computing.com


-----Original Message-----
From: Rogers Michael L
[mailto:mssqldba-ezmlmshield-x23460259.[Email address protected]
Sent: Wednesday, June 29, 2005 12:19 PM
To: LazyDBA Discussion
Subject: Changing a connection on DTS

Why is it that every time I want to make a simpe connection change in a
DTS package that I essentially have to re-write everything? Am I the
only one that has problems with this? I change the connection and have
to re-do the transformations, then, when I run it, it still point to the
old tables/connection even though I have changed everything.

Frustrated again



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page