Hello,

I'm going to use a DTS package to move multiple MDB files into SQL Server
2000. Is there anywere that has good example of different parts of DTS
package? The package I need to create will keep checking a certain network
folder to see if a new MDB exists. If so, I'll move it into the SQL Server,
then move the MDB file to a subfolder, then I'll check to see if any other
MDB files exist on the network folder.

Thanks

Don

In message <bBKBc.6983$Pt.4159 (AT) newssvr19 (DOT) news.prodigy.com>, Don
<dons100 (AT) ameritech (DOT) net> writes
How about this-

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

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

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