Run a DTS Package by a user not haing all the rig

• jaybmehta

  SSChasing Mays

  Points: 637

  More actions

  December 3, 2002 at 9:43 pm

  #105976

  Hello All

  I have a problem.

  We have a file that will be uploaded to the webserver whenever there r changes made to the file.

  Now we have to get some columns of the file and put that data in our table in the database. Now since this is done through a HTML page and the connection to the DB server will be normal user i am not able to run the DTS package from the store procedure, as the member of sysadmin user will only able to run "dtsrun" utility.

  Does any 1 know how do i do this. What i have done is created the stored procedure and which will run the job and the job will run the dts package. Can any1 tell me the solution, abt how do go abt it. Is there any better way to do it.

  Regards

  Jay

• Antares686

  SSC Guru

  Points: 125444

  More actions

  December 4, 2002 at 5:37 am

  #443062

  Check out this thread. http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3389&FORUM_ID=19&CAT_ID=3&Topic_Title=Run%20DTS%20package%20from%20stored%20procedures&Forum_Title=Data%20Transformation%20Services%20(DTS)