Post reply

DTS generating text file

  • June 8, 2005 at 1:00 am

    #74932

    I just want to ask what authentication or login is used by DTS when generating text file in a shared folder? What account is used to access the folder? is it the account of the one executing the package?

    :-):cool:

  • June 8, 2005 at 2:56 am

    #563750

    It is always the account that executes the package.

    IE If you schedule the package as a job it will be the account that the sql server agent runs as.

    If you execute the package via your own pc, it will be you.

     

    etc.....

    ------------------------------
    The Users are always right - when I'm not wrong!

  • June 8, 2005 at 2:57 am

    #563752

    If you are running the Package as a Job, usually it is the SQL Server Agent account.  If you are in Interactive mode, it will access the FSO via the account you are logged in as.  If you run the Package from a stored procedure, chances are good that it is executing under the SQL Service account.

    There was a post on here about a week ago that explained when the SQL proxy account is used, and I believe this is also available in the BOL (books online).

    -Mike Gercevich

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply