Post reply

SSIS DTExec,DtsDebugHost,dtshost config settings

  • March 21, 2012 at 2:09 am

    #270401

    When trying to execute SSIS package, I am getting "Access Denied"

    Package Protection level : "Dont Save sensitive"

    Previously I was able to run the same package with no issues,

    ADMIN USER has modified the below config files

    DTExec.exe.config

    DtsDebugHost.exe.config

    dtshost.exe.config

    NOTE :ADMIN user is able to run the same package now with no issues!!

    Can anybody help?

  • March 21, 2012 at 2:58 am

    #1462051

    Also I am getting Access Denied when trying to view the above config files even after reverting the changes

  • March 21, 2012 at 3:04 am

    #1462053

    It seems you don't have sufficient permissions.

    Are you running the package in BIDS or on the server?

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

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

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