Loop In DTS Package

[dzdncnfsd]

This may not be the correct forum for this question, but I am starting here and will move on if necessary. I need to import data from ten Access2000 databases on three different servers into consolidated tables in a SQL 2000 database located on a fourth server. I created one package that contains the normal source/destination information for all of the tables in one database. I have a second package that contains an ActiveX script that is supposed to loop through all of the databases, importing data from all of the separate tables into SQL tables. I want the script to change the path dynamically, but instead it reimports data using the path that was referenced when I created the package in the first place - once for each of the 10 locations. Does anyone have any ideas about how to do this?
Thanks for any help you can give me.
Gladys Clemmer
gladys.clemmer@goldkist.com

 

[tlbroadbent]

Gladys,

The SQLDTS website might have the answers you need. See the articles at the following links.

How can I change the filename for an Access Connection?

http://www.sqldts.com/main.asp?nav=1,6,201,0

Changing the DataPump Source and Destination Tables

http://www.sqldts.com/main.asp?nav=1,6,213,0

Darren Green also provides DTS info, samples and downloads at SWYNK.COM.

http://www.swynk.com/friends/green/

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[dzdncnfsd]

Thanks very much. I will check them out.
Gladys
Gladys Clemmer
gladys.clemmer@goldkist.com