I was wondering about the maximum number of tables that
could be imported by one DTS package. The SEARCH seems to
be inop - otherwise I wouldn't bother y'all.

I have personally done 1500 but I do not see why there should be any limit
per se. Manageability would be one concern with a large amount.

--


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

"Bill G" <goldbergwj (AT) ci (DOT) gainesville.fl.us> wrote