I need to make a generic connection to the server where the DYS package
is. eg. If the package is on server ABC, then the connection should be
to server ABC. How can I do this ?
Thank you in advance





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You add a connection and then use 1 of a variety of methods to change the
DataSource property of the server connection

You can use

1. A Dynamic Properties task
2. Global Variables along with DTSRUN with the /A switch.
3. The object model in either an Active Script task or 3rd party app
outside of the package.

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

"Nasira Jamal" <njamal (AT) iqgroup (DOT) net> wrote