Similar projects (SSIS package)/suggestions. -- sql server dts

Lam Nguyen
8/22/2007 9:26:02 AM

I have to write a SSIS package to transfer data from production server which
has about 120 databases to dev server. Each database has 160 tables and each
table I only need a few columns out of it. Has anyone had done a similar
project like this or know of a best way to do it. The trick for me is
finding a way to pass in database name for each 120 databases. We are
provide services to client and each client has it own database. Also, Does
anyone a good sources/projects on SSIS packages similar to this as well. Any
helps would greatly appreciate.

Lam

Allen H.
8/22/2007 2:02:02 PM

Microsoft's SmoTablesDBCC sample demonstrates using a ForEach SMO enumerator
to iterate over tables. The same thing could be done with databases.

Download the sample from MSDN. By default they are installed at:

C:\Program Files\Microsoft SQL Server\90\Samples\Integration
Services\Package Samples\SmoTablesDBCC

Allen

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Similar projects (SSIS package)/suggestions.