DTS Examples of moving data from Access to SQL Server

[DonS100]

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

 

[nigelrivett]

Well I wouldn't do this using dts - here's an example using text files - you could use a similar thing but call a dts package for the import or just use openrowset.

http://www.nigelrivett.net/ImportTextFiles.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.