Post reply

calling SSIS from sp and getting permission issue...

  • July 23, 2008 at 7:42 am

    #188480

    Hi, i am calling a SSIS from sp using bellow syntax..

    EXEC Master..XP_cmdshell 'DTExec /FILE "C:\OCN_SYSTEM_SSIS\OCN_SYSTEM\OCN_SYSTEM\FETSIMPORT.dtsx"'

    i am facing the error 'the Execute permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'

    i have tried all the passibillities in google, but i didn't find 'mssqlsystemresource' database and i don't know how to permissions for the user?

    can any one help?

    Thanks,

    Balu

  • July 23, 2008 at 7:48 am

    #847043

    Grant Execute permission on xp_cmdshell in Master to the user.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • July 23, 2008 at 10:07 am

    #847172

    i ran Grant Execute on xp_cmdshell in Master to the 'user'

    it says success, but after i ran the application still giving same error

  • July 23, 2008 at 10:18 am

    #847180

    Can you try a shot to execute XP_cmdshell alone like

    Exec xp_cmdshell 'dir c:\' to verify whether it's Problem from this SP's Permissions or SSIS Permissions for User. Have you checked the SSIS Package's security setting .

  • July 23, 2008 at 11:08 am

    #847235

    i tried like, executing sp thru QA, its works fine(witout error ssis running currectly)..but when i pull thru .Net app..it is giving problem.

Viewing 5 posts - 1 through 4 (of 4 total)

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