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 |
|
SuzyB_24
Starting Member
11 Posts |
 Posted - 2003-03-27 : 11:29:43
|
| I have an SQL Server 2000 database that needs to be updated from 2 separate MS Access 97 databases. At the moment I have a DTS package that takes each table in turn, deletes the existing data from it and imports the new data (using Execute SQL tasks and Transformations respectively).This looks a clunky solution that, at present, doesn't work correctly. Is there a better way to do this, or if not, is there any way to run the package from an ASP.Net page, returning success/failure notification back to the page.ThanksSuzyB |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-27 : 18:16:51
|
| Of course you could run the package from a programming language such as ASP.NET. You just have to call the DTS package from xp_cmdshell which is not recommended due to the privileges the user would get.Why do you think that your solution looks clunky? What isn't working correctly?Tara |
 |
|
|
SuzyB_24
Starting Member
11 Posts |
Posted - 2003-03-28 : 11:26:11
|
| I was thinking my package was clunky because I have a delete sql task and a transform data task for each table I needed to update. I'm pretty sure I need to do it this way though.I been having another look at it today and I've found why it wasn't working. As is often the case human error is to blame. The paths to the Access files were wrong (DOH!).I've managed to get it working now, I call a stored procedure from the ASP.NET page which runs the DTS package using xp_cmdshell (thanks for the pointer). I then check my log table to see if any errors occurred and report back. Seems to work OK just now but it'll need a bit of testing to make sure.Thanks againSuzyB |
|
|
|
|
|
|
Import from Access