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 |
|
severtki
Starting Member
2 Posts |
 Posted - 2008-02-02 : 11:46:25
|
| A seemlingly common scenario, but one that has proven surprisingly frustrating to implement:I have a number of clients running an Access application, and I provide a web catalog for them. I'd like to fully automate the process of 1) exporting their updated data, 2) uploading to web server, and 3) import into SQL db (delete existing data; insert new data). 1 and 2 are no problem, of course. Import into SQL is most obviously done manually using web interface to SQL Server (my host does not allow remote SQL connections, or I would do so directly from client's Access apps).I don't want to have to manually import the uploaded file. I'd love some suggestions on how to automate this from an ASP script (client app would open a URL to initiate the script, which would run the import process itself).Everything I read about using DTS, SSIS, etc. for this kind of job assumes I'm using SQL Server Management Studio. Any pointers on information on scripting this in ASP instead?Thanks in advance,Kirk |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-02 : 21:48:27
|
| You can create a sql job for ssis package and start the job with msdb..sp_start_job in asp. |
 |
|
|
severtki
Starting Member
2 Posts |
Posted - 2008-02-03 : 13:04:50
|
| Thanks for the answer, rmiao. Just found out that my web host doesn't support DTS or SSIS, unfortunately.Two other ideas I had: -- open connections directly to an uploaded Access DB and the SQL DB and use SQLBulkCopy or -- export tables to another format such as XML or CSV and import them.Any particular recommendations? Thanks again,Kirk |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-03 : 13:52:24
|
| Possible to set linked server in sql to Access file? |
|
|
|
nadigarsoo
Starting Member
5 Posts |
Posted - 2010-03-05 : 22:54:27
|
| You can Visit the site http://www.goresellers.com/ To purchase the Server Plans at low by being a reseller ...VENKAT t |
|
|
|
|
|
|
|
|
Import data from ASP script (web host)