Re: Package Sercurity Context

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: alien2_51 (dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion)
Date: 03/02/04

  • Next message: Brent Bigler: "Help for somewhat complicated text file import." 
    Date: Tue, 2 Mar 2004 14:39:50 -0800

    Thanks Darren...

    "Darren Green" <darren.green@reply-to-newsgroup-sqldts.com> wrote in message
    news:AkgHHREmCNRAFwhi@sqldts.com...
    > In message <ebqh0YHAEHA.1548@TK2MSFTNGP12.phx.gbl>, alien2_51
    > <dan.billow@?.o.s.p.a.m.monacocoach.commercialversion.invalid> writes
    > >Under what security context does an ActiveX Script task run as if
    executed
    > >inside the DTS designer...? Where does it get the context, does it
    > >impersonate the user..? I realize that it's different when run as a
    > >scheduled job, whatever credentials the SQL Agent runs under are used...
    Is
    > >that correct..?
    > >
    > >TIA
    > >
    > >
    > The script and indeed the package is run under the context of the user
    > executing the package. DTS is client-side, so when using Enterprise
    > Manager for example it runs on the same machine as EM, under the user
    > context of logged on user.
    >
    > If you schedule a package then you basically get the SQL Server Agent
    > service to call DTSRUN for you, so it is on the same machine as SQL
    > Server Agent and running under the SQL Server Agent service account. The
    > caveat to that is for jobs not owned by a sysadmin SQL agent then
    > impersonates the proxy account, assuming one has been defined.
    >
    > More info about scheduled packages here-
    >
    > http://support.microsoft.com/default.aspx?scid=kb;en-us;269074
    >
    > --
    > Darren Green (SQL Server MVP)
    > DTS - http://www.sqldts.com
    >
    > PASS - the definitive, global community for SQL Server professionals
    > http://www.sqlpass.org
    >

  • Next message: Brent Bigler: "Help for somewhat complicated text file import."

    Relevant Pages

    • Re: Package Sercurity Context
      ... Where does it get the context, ... DTS is client-side, so when using Enterprise ... If you schedule a package then you basically get the SQL Server Agent ...
      (microsoft.public.sqlserver.dts)
    • Re: Can you use osql in DTS?
      ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
      (microsoft.public.sqlserver.dts)
    • Re: Can you use osql in DTS?
      ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
      (microsoft.public.sqlserver.programming)
    • Re: Migrating DTS Local Package from test to production environments v7.0
      ... The version of SQL Server on which the package was create is SQL Server ... DTS runs at the client so manually will be on the invoker's PC which in this ...
      (microsoft.public.sqlserver.dts)
    • RE: Migrating DTS to Integration Services
      ... let me answer your Encryption issue when you expand your MSDB ... used to connect to your SQL Server, ... Open services.msc and restart your SQL Server Integration Service. ... Migrate DTS 2000 packages or Add Existing package (since you have migrated ...
      (microsoft.public.sqlserver.dts)