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-02-06 : 18:01:06
|
Roy writes "I'm building a data warehouse where users will occasionally need to insert large blocks of data from remote locations. The source data will be contained in Excel spreadsheets.
My thought is to have the users FTP the spreadsheets to a server linked to the database server and execute a job via the web which will a DTS package to run.
Does this seem reasonable? Does anyone have experience with such a scenario? I'd be grateful for any tips, tricks, or pitfalls that you might be willing to share.
Thanks in advance,
Roy" |
|
|
|
|
|
DTS job to import Excel spreadsheet into SQL 7 DB over the web.