Copy a continuously changing list of Tables - 09-18-2003 , 09:05 AM
I would like to create a DTS package to determine a list
of USER tables in a SQL DB and copy them to another SQL
DB. The list will change continously.
Re: Copy a continuously changing list of Tables - 09-18-2003 , 09:12 AM
I would probably build a custom task using SQL DMO and Export from there.
You could then drop tables on the destination and reapply through the
scripts and data export.
Allan Mitchell (Microsoft SQL Server MVP)
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Bradley Anderson" <Bradley.Anderson (AT) ge (DOT) com> wrote