dynamic config of connection manager

#1

My scenario is like this:

We have 9 equal databases located on 9 different physical locations in the
country. I am going to import data from these databases into a dataware house
using the same sql statements.

In our current solution there are 9 equal DTS-packages that each connect to
a specific source server.

Now I would like to loop over these 9 connections and hence only have 1
package to deal with.

How do I dynamically update the connection information for each round of my
loop? Where do I store the connection information, database table or in a
(XML) file?

Thanks in advance for your help!

#2

For clearity: My question is regarding integration services (SSIS). Our
current running system is DTS (SQL 2000).

"Billy" wrote:

Quote:

My scenario is like this:

We have 9 equal databases located on 9 different physical locations in the
country. I am going to import data from these databases into a dataware house
using the same sql statements.

In our current solution there are 9 equal DTS-packages that each connect to
a specific source server.

Now I would like to loop over these 9 connections and hence only have 1
package to deal with.

How do I dynamically update the connection information for each round of my
loop? Where do I store the connection information, database table or in a
(XML) file?

Thanks in advance for your help!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

dynamic config of connection manager

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

dynamic config of connection manager - 12-15-2005 , 04:21 AM

RE: dynamic config of connection manager - 12-15-2005 , 01:55 PM