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 |
|
lynnami
Starting Member
2 Posts |
 Posted - 2005-07-02 : 13:02:33
|
| I am a bit of a newbie and realise this may seem like a bit of a dumb question but any help will be appreciated.I have an IIS (Webserver) and a SQL7 Server(SQL-Server) running on separate machines on the LAN.I have created several DTS packages which involve SQL statements, Object Transfers and Data Transformations and using SQL Authentication for userid and password and saved as local packages on SQL-Server. The packages all work 100% from within Enterprise Manager and also using the dtsrun utility in Query Analyser. The packages will need to run from within a web application created in ASP. I have created a test ASP page to execute the packages but I get a login error (generated by ASP code and not IIS) as the ASP page uses the default web user on 'Webserver' (Webserver\IUSR_Webserver). I have no doubt that it is a permissions problem between SQL-Server and Webserver but I am at a loss on how to solve it. Would it be preferable to save the packages as files and call these from ASP or is there a really clever method I have no knowledge of?Any help will be appreciated.thanksLynnami |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-07-03 : 15:16:56
|
| If the packages are saved in the server then the user will need to be able to login to the server to extract them before running - which means adding your user and giving permission on msdb.If you save them as files then they can be run if you have permission on the directory - then you just need permissions to do whatever the package does.==========================================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. |
 |
|
|
lynnami
Starting Member
2 Posts |
Posted - 2005-07-04 : 12:16:26
|
| Thanks so much - I think this will solve my problemLynnami |
|
|
|
|
|
|
Execute DTS package from ASP page