• Satu (11/6/2013)


    In database engine I have sysadmin role but when one connects to Integration Services (instead of Database engine) Windows credentials are used. I have gathered that the packages are actually run under the Windows account they are started with. I suspect that this problem has nothing to do with privileges given to any login in database engine, but could be wrong.

    -- Satu

    The SSIS packages are run under the credentials by the user who starts them.

    In other words, if you login into SSIS, right click the package and choose execute, the package will run under your permissions.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP