Hello!

DTS pacakge (2 connecttions):
Source: Sql server name (abcd)
Target: Sql server name (abcd)

I have a DTS package that has two sql server connections (source and
target). The server is same (abcd) for both source and target sql
servers. I need to use global variable for the server name property (bc
of promoting this pacakge to another server 'xyz'). Using Disconnect
Edit, I set up a global variable 'gvServer' to 'Data Source property' of
source sql server. I set the same variable for 'target sql server'. When
I ran the pacakge, it did change the server name of target sql server to
'xyz' but the value of source sql server remained the same i.e. 'abcd'?
Why the global variable updated only one connectoin? Do I need to create
two variables for each
connection? what I am missing hee?

Thanks for your help!










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

Does anybody has any idea on this? Thanks!




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

Customer specific price matrix design (Long)
Update Query question.
The command(s) completed successfully. - Can i turn this output off?
preparing monthly report
Parsing spaces