Migrating DTS to several locations

#1

I have over 182 DTS packages that reside on 54 SQL servers each is a diffrent
server, the DTS packages pull data from SQL server databases, sybase &
oracle. The plan is to move the databases to 4 SQL servers, is there an easy
why to find which DTS package uses which databases so we would now what to
migrate a long with the databases. Thanx

#2

The only way I could think to do it would be to

Use the Object Model
Loop through the packages
Look at the Connections Collection
Find the SQL Server connections
Check their Catalog property.

Allan

"SQLCluster" <SQLCluster (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have over 182 DTS packages that reside on 54 SQL servers each is a
different
server, the DTS packages pull data from SQL server databases, sybase &
oracle. The plan is to move the databases to 4 SQL servers, is there an
easy
why to find which DTS package uses which databases so we would now what to

migrate a long with the databases. Thanx

#3

Allan,

Could you PLEASE explain a bit more on the object model.
Is this VB Scripting?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

The only way I could think to do it would be to

Use the Object Model
Loop through the packages
Look at the Connections Collection
Find the SQL Server connections
Check their Catalog property.

Allan

"SQLCluster" <SQLCluster (AT) discussions (DOT) microsoft.com> wrote in message
news:SQLCluster (AT) discussions (DOT) microsoft.com:
I have over 182 DTS packages that reside on 54 SQL servers each is a
different
server, the DTS packages pull data from SQL server databases, sybase &
oracle. The plan is to move the databases to 4 SQL servers, is there an
easy
why to find which DTS package uses which databases so we would now what
to

migrate a long with the databases. Thanx

#4

Sure

Enumerating DTS Packages using VB.Net
(http://www.sqldts.com/default.aspx?250)

You can then grab the package
Open it
Change a DataSource

http://www.sqldev.net/dts/ExecutePac...isual%20Csharp

You can find the object model in BOL (Books Online)

http://www.microsoft.com/sql/techinf...2000/books.asp

"MADS" <deschepper_marc (AT) telenet (DOT) be> wrote

Quote:

Allan,

Could you PLEASE explain a bit more on the object model.
Is this VB Scripting?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message
news:%23jdCSM6CFHA.2156 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
The only way I could think to do it would be to

Use the Object Model
Loop through the packages
Look at the Connections Collection
Find the SQL Server connections
Check their Catalog property.

Allan

"SQLCluster" <SQLCluster (AT) discussions (DOT) microsoft.com> wrote in message
news:SQLCluster (AT) discussions (DOT) microsoft.com:
I have over 182 DTS packages that reside on 54 SQL servers each is a
different
server, the DTS packages pull data from SQL server databases, sybase
&
oracle. The plan is to move the databases to 4 SQL servers, is there
an
easy
why to find which DTS package uses which databases so we would now what

to

migrate a long with the databases. Thanx

#5

There is some simple demo code that you can adapt as a start point, see
Transfer Packages Sample Application -

Tools & Tasks
(http://www.sqldts.com/?272)

Cheers

Darren

In message <eT1i2XIDFHA.3504 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, Allan Mitchell
<allan (AT) no-spam (DOT) sqldts.com> writes

Quote:

Sure

Enumerating DTS Packages using VB.Net
(http://www.sqldts.com/default.aspx?250)

You can then grab the package
Open it
Change a DataSource

http://www.sqldev.net/dts/ExecutePac...isual%20Csharp

You can find the object model in BOL (Books Online)

http://www.microsoft.com/sql/techinf...2000/books.asp

"MADS" <deschepper_marc (AT) telenet (DOT) be> wrote in message
news:deschepper_marc (AT) telenet (DOT) be:
Allan,

Could you PLEASE explain a bit more on the object model.
Is this VB Scripting?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message
news:%23jdCSM6CFHA.2156 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
The only way I could think to do it would be to

Use the Object Model
Loop through the packages
Look at the Connections Collection
Find the SQL Server connections
Check their Catalog property.

Allan

"SQLCluster" <SQLCluster (AT) discussions (DOT) microsoft.com> wrote in message
news:SQLCluster (AT) discussions (DOT) microsoft.com:
I have over 182 DTS packages that reside on 54 SQL servers each is a
different
server, the DTS packages pull data from SQL server databases, sybase
&
oracle. The plan is to move the databases to 4 SQL servers, is there
an
easy
why to find which DTS package uses which databases so we would now what

to

migrate a long with the databases. Thanx

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

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

Migrating DTS to several locations

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

Migrating DTS to several locations - 02-05-2005 , 09:59 AM

Re: Migrating DTS to several locations - 02-05-2005 , 10:53 AM

Re: Migrating DTS to several locations - 02-06-2005 , 12:48 PM

Re: Migrating DTS to several locations - 02-06-2005 , 01:57 PM

Re: Migrating DTS to several locations - 02-07-2005 , 02:15 PM