Re: Permission required to execute a DTS package from ASP.NET app

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"Ray5531" <Ray5531@xxxxxxxxxxxxx> wrote in
news:#QTNS10hFHA.3164@xxxxxxxxxxxxxxxxxxxx:

> Hello,
>
> I'm calling a DTS package from my asp.net application.Apparently
> because of permission issue I canot run the package within the sql
> server ,because when I set it to call a package from my local host it
> can execute te package.one step before calling the package I get the
> IDENTITY of the current security context and it is my Domian user name
> and I'm using IntegratedSecurity to call the DTS package.I'm also
> memeber of sysadmin rols in Database.Do I have to give it extra
> permissions?
>
> Thasnk
>
>
>

Hi Ray,

If you are using SSPI in the connectionstring, you have to impersonate the
call to the DTS.
You can do that by adding the next line to the web.config:
<identity impersonate="true" />

link: http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/vsent7/html/vxconImpersonation.asp


Pablo
.

Relevant Pages

  • Permission required to execute a DTS package from ASP.NET app
    ... I'm calling a DTS package from my asp.net application.Apparently because of ... permission issue I canot run the package within the sql server,because when ... step before calling the package I get the IDENTITY of the current security ...
    (microsoft.public.dotnet.framework.aspnet)
  • Permission required to execute a DTS package from ASP.NET applicatio?!!
    ... I'm calling a DTS package from my asp.net application.Apparently because of ... permission issue I canot run the package within the sql server,because when ... step before calling the package I get the IDENTITY of the current security ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Process Cube Task
    ... It has a command-line interface -- so you would use a DTS Process Task ... private dimension that contained more than 2 million members. ... occasionally the cube would process, and that was throwing me off. ... DTSRUN of the package from the command-line. ...
    (microsoft.public.sqlserver.olap)
  • Re: Is there a limitation on the number of Tasks that can Run in Parellel ?
    ... Allan Mitchell MCSE,MCDBA, www.SQLDTS.com - The site for all your DTS needs. ... >> Before the sending the mail yesterday, I did increase the number of Tasks executed in Parallel to 20 in the DTS Package>> Properties window. ... >> Step Error Source: Microsoft Data Transformation Services Package Step Error Description:SubStep ... Step Error code: 80040428 Step Error Help>> File:sqldts80.hlp Step Error Help Context ID:1100>> Step Error Source: Microsoft Data Transformation Services Package Step Error Description:SubStep>> 'DTSStep_DTSDataPumpTask_10' failed with the following error: OleDBProperty 'General Timeout' already exists in the collection. ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS Hanged When Scheduled
    ... Please feel free to respond to the newsgroups if you need any ... Microsoft Online Support ... | Subject: RE: DTS Hanged When Scheduled ... this behavior occurs because the package is using ...
    (microsoft.public.sqlserver.dts)