Execute DTS via web server

  • Here is the scenerio:

    1. asp.net web app needs to execute a DTS package.

    2. asp.net subweb is set to "NT Athentication" -- Anonymous turned off.

    3. ASP.Net package is located on webserver

    4. DTS package located on SQLServer.

    5. DTS package must visit Fileserver and get text file to load into SQL.

    The problem?

    Double-hop. The web server can take the logged on user credentials to do stuff to the application. But, it cannot forward the credentials to the SQL server.

    The DTS needs a domain user account to execute because it must go to another server on the domain an retrieve a text file. SQL user authenication does not have domain permissions to retrieve the file.

    So....What are our options? How can we resolve this?

  • This was removed by the editor as SPAM

  • I would.

    Call the dts package from the web page by passing in a sql server username and password when calling the package. Like so:

    Extract from web page: http://www.sqldts.com/?208,2

    ============================================================

    ' Load Package

    oPKG.LoadFromSQLServer sServer, sUsername, sPassword, _

    DTSSQLStgFlag_Default, , , , sPackageName

    ' Set Exec on Main Thread

    For Each oStep In oPKG.Steps

    oStep.ExecuteInMainThread = True

    Next

    ' Execute

    oPKG.Execute

    ============================================================

    Why do you not then give the sql server account access to the file server and drive where the doucment resides.


    ------------------------------
    The Users are always right - when I'm not wrong!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply