Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-24 : 08:48:15
|
john writes "There are more than 2500 data sources deployed in the united states that contain small access databases that need to be returned to our central data store.
We will be ftp'ing all of the data on a nightly basis (it isn't alot per source or this would be out the window) to a network file server.
My problem is in getting all of this data into a table, making sure the file for a particular source was found, notifying of failures and what not.
Since i will literally be looking into an ftp directory that contains thousands of files, what's the best means to go about getting that data into the database but still be able to manage the entire process.
DTS looks interesting but I read some comments on this site that say to stay away from using it until it has matured.
Are there other avenues to take, or existing tools that would be better suited to manage this task?
All is SQL2K, Win2K here.
thanks!" |
|
|
|
|
|
DTS or BCP 2500+ data sources to central data store