Re: How to Change datasource, username and password on batch import
- From: Allan Mitchell <allan@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 07 Mar 2006 14:46:47 -0800
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
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.
.
- Prev by Date: Re: alternative to Enterprise Manager GUI for DTS?
- Next by Date: Re: new ssis is not as good as DTS
- Previous by thread: How To Copy Tables Across Servers?
- Next by thread: Re: New schedule DTS job always failed
- Index(es):
Relevant Pages
|
