Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    25

    Question Unanswered: DTS execution account

    hi all,

    I hace a DTS package that contains a transformation task and an ActiveX Script Task (the last task accesses the registry in order to read some values). So first, does anybody knows under what user account the DTS package will run? and second what permissions should the account have in order to execute the DTS?.

    Thanks in advance.

    God Bless.

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245

    Re: DTS execution account

    The answer is that it depends (you knew I was going to say that).

    If it is run interactively, it will run under the login of whoever is logged in (it will also run in the client context of your login, so if you are using EM from a client workstation and are not using it through Terminal Services, watch out!)

    If it is run via a SQL Server job, then it will run in the context of the SQL Agent Service.

    If you schedule it using NT Scheduled tasks, you can specify the user when setting up the task.

    If ou execute it from an SP, I think you can specify the user context (though I don't swear to that -- it might pick up the user context of the person executing the SP).

    Originally posted by mvargasp
    hi all,

    I hace a DTS package that contains a transformation task and an ActiveX Script Task (the last task accesses the registry in order to read some values). So first, does anybody knows under what user account the DTS package will run? and second what permissions should the account have in order to execute the DTS?.

    Thanks in advance.

    God Bless.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •