sql server dts: I am new to DTS and I am trying to figure out how to do something
I have written a routine that connects a local SQL server to a remote SQL server and does some data exchanges. The problem is that there are 40 remote servers that I need to connect to all with different passwords. In addition, the passwords can change as well as the data fields that need to be exchanged. I can bite the bullet and create 40 packages but I hate the idea of having to modify the packages every time there is a data field change and/or a password change. I ahve seen things about lookup queries but it does not appear to allow me to do what I need. I cannot do this in VB, it must be in SQL DTS so there goes that idea

You can manipulate whatever you want using the Object Model.
You can set the server, user, source object etc etc etc.

If the source and destination objects are very dynamic as are the Data
Sources then you will essentially be recreating the package each time.

We have examples of setting object properties on the site www.SQLDTS.com

--

----------------------------
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



[quoted text, click to view]
server and does some data exchanges. The problem is that there are 40 remote
servers that I need to connect to all with different passwords. In addition,
the passwords can change as well as the data fields that need to be
exchanged. I can bite the bullet and create 40 packages but I hate the idea
of having to modify the packages every time there is a data field change
and/or a password change. I ahve seen things about lookup queries but it
does not appear to allow me to do what I need. I cannot do this in VB, it
must be in SQL DTS so there goes that idea.
[quoted text, click to view]