Re: Security

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

From: AnthonyThomas (Anthony.Thomas_at_CommerceBank.com)
Date: 12/13/04 

Date: Mon, 13 Dec 2004 07:21:11 -0600

You are correct, but if you have any ActiveX or any file level transfers
that use NTFS permissions, those will have to be ran under the context of
the user executing the package, you or the SQL Agent account.

In the main package properties, you can enable package level logging. Turn
this on, then when it is ran, you can determine the exact cause of failure,
not just the job level failure notice.

Sincerely,

Anthony Thomas 

-- 
"mat" <mat@discussions.microsoft.com> wrote in message
news:D93B7A67-FDE5-49CC-919E-33BEE08A3ECD@microsoft.com...
Thanks
The connection within the package uses a SQL login for the SQL server it
connects to, so even though it is executing using the  agent, so using the
agents permissions, i presumed that the actual connection will be made using
the defined login.
is this true?
"Uri Dimant" wrote:
> mat
> When you execute the DTS  by clicking on the package  it is running under
> permissions that defined on your workstation (local account probably) , as
> opposite when it runs with a job ,it should be run under SQL Server Agent
> account (It should be most likely a domain account)
>
>
>
> "mat" <mat@discussions.microsoft.com> wrote in message
> news:5520F76E-AE6E-4B14-AE67-2CCBBC4179DC@microsoft.com...
> > I have a dts package that transfers data from one sql server to another.
> it
> > uses a SQL login to connect to the second server. When the DTS package
is
> > executed it runs fine but if it is executed from a job or using the
dtsrun
> > utility it always fails
> >
> > Can anyone help?
>
>
>

Relevant Pages

  • Re: Access while running DTS package using stored procedure
    ... The permissions when executing xp_cmdshell can be different depending on who ... which the SQL Server service is running. ... > I wrote a DTS Package that can take the data from a .txt file residing ... > Declare @RunDTS as varchar ...
    (microsoft.public.sqlserver.dts)
  • RE: SQL 2008 - remote connection to the SSIS 2008 - Access denied
    ... SQL Server configures the appropriate rights during the installation process, ... then add users/groups and assign the appropriate permissions. ... user who created the package apply to the writer role. ... I checked DCOM MsDts component and my user rights for the Remote ...
    (microsoft.public.sqlserver.dts)
  • RE: Could not open global shared memory to communicate w/ performa
    ... If look at my post titled Permissions Problem and dated 12/13/2008, ... db_ssisoperator and I granted db_ssisoperator the Reader Role via the Package ... On the SQL Server box, open Programs, SQL Server 2008, COnfiguration Tools, ... I am logged in as domain administrator yet still have ...
    (microsoft.public.sqlserver.dts)
  • RE: Could not open global shared memory to communicate w/ performa
    ... a package in BIDS (business Intelligence Development Studio, ... On the SQL Server box, open Programs, SQL Server 2008, COnfiguration Tools, ... for executing SSIS Packages. ... I am logged in as domain administrator yet still have ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS/SQL 2000 Error on Import: External table is not in the expected format
    ... I just want to pursue the permissions thing further as the error ... The SQL Server Agent Service? ... The package works fine if executed manually. ...
    (microsoft.public.sqlserver.dts)