Hello!

I have a DTS package that has two sql server connections. The server
name is same. I need to use global variable for the server name
property. Using Disconnect Edit, I created and set my variable
'gvServer' to Data Source of "Connection 1". I set the same variable for
"Connection 2"?. Is that wrong? Bc trying running a package tellign me
sql server does not exist for "connection 1". The same value is not
passing for both connections. Do I need to create two variables for each
connection (even though the value and property is same)? What I am
missing here? Please let me know.

Thanks for your help!






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