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.

Any ideas?

Thanks
Bradley

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)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Bradley Anderson" <Bradley.Anderson (AT) ge (DOT) com> wrote