sql server dts: DTS Examples of moving data from Access to SQL Server -- sql server dts

DTS Examples of moving data from Access to SQL Server

Don
6/21/2004 11:56:55 PM

sql server dts: 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

Re: DTS Examples of moving data from Access to SQL Server

Darren Green
6/22/2004 1:35:29 AM

In message <bBKBc.6983$Pt.4159@newssvr19.news.prodigy.com>, Don
<dons100@ameritech.net> writes
[quoted text, click to view]

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