Hi,

I have around 300 tables to import from an Access database to an MS SQL
server. I want to be able to store the DTS package into a file so I can use
it to populate my MS SQL database from the Access database in my setup and
deployment project. The problem is the datasource of both my access and ms
sql will change at the setup so I will need to give the datasource, user and
password to the DTS for ALL of my tables.

I have use the import&export wizard to generated the DTS for my 300 tables.
This is not a problem. The problem is that the wizard generated 600
connections to import the thing. In reallity, I only need two connection.

I could attached a dynamic property (to use a global variable) for EVERY of
my connection that will change all the datasource, username and password and
it would work. The problem is doing that manually for the 600connetions will
take VERY LONG. Is there any way I can transform my 300 tables with only 2
connections insteed of 600 (in that case, changing 2 connections is not long
to do at all).

Any help will be appreciated.

thanks.

Hello abuck,

You will probably find that the wizard generated copies of connections and
you probably only have around 4 actual connections. This means you change
those and they all fall in line.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com