Hello!

Using Dynamic Properties Task, how do I change db name at runtime using
global variable? My DTS pkg has two connections. All I am trying is to
change the db name at run time for a target connection. So, I set up a
global variable "gvDB" on "Catalog" (is this correct?) on the target
connection. I ran the package. The package did change the Catalog name
with the new db name but it did not work bc the "data pump" which has
"destinationobjectname" (dbname.dbo.tablename) property showing the old
dbname tablename. How do I change that? Why "gvDB" did not change
destination db name? What I am missing?

Thanks for your help!



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

Yes Catalog on the connection manager is correct

Here is the answer to the other Q

Go into disconnected edit and change the
DestinationObjectName/SourceObjectName to be

Owner.ObjectName instead of db.owner.objectName

Allan

"Test Test" <farooqhs_2000 (AT) yahoo (DOT) com> wrote

Thank you, Allan. It works!!!!



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