Cann't run SSIS package using sql agent.

  • Hi all,

    we have one new server installed with two instances. One is test and other is prod.

    Server\prod instance is working good when i run ssis package using SQL Agent, But when i use Server\test I am getting the error:

    Executed as user: Team\sqlserver. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 2:08:59 PM Could not load package "\MSDB\Package" because of error 0x80040E09. Description: The EXECUTE permission was denied on the object 'sp_ssis_getpackage', database 'msdb', schema 'dbo'. Source: Microsoft SQL Server Native Client 10.0 Started: 2:08:59 PM Finished: 2:08:59 PM Elapsed: 0.297 seconds. The package could not be loaded. The step failed.

    I Have Sys admin privileges on that instance, Do i need more access? or Team\sqlserver needs anything more to execute the package?

    Team\sqlserver has these privelages:

    db_ssisoperator.

    rs_execrole

    db_ssisadmin

    db_ssisltduser

    sqlagentoperatorrole.

    sqlagentreaderrole.

    sqlagentuserrole.

    Please help its urgent. I have searched so many forums since yesterday but couldn't get enough information about it.

  • srilu_bannu (11/1/2011)


    Hi all,

    we have one new server installed with two instances. One is test and other is prod.

    Server\prod instance is working good when i run ssis package using SQL Agent, But when i use Server\test I am getting the error:

    Executed as user: Team\sqlserver. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 2:08:59 PM Could not load package "\MSDB\Package" because of error 0x80040E09. Description: The EXECUTE permission was denied on the object 'sp_ssis_getpackage', database 'msdb', schema 'dbo'. Source: Microsoft SQL Server Native Client 10.0 Started: 2:08:59 PM Finished: 2:08:59 PM Elapsed: 0.297 seconds. The package could not be loaded. The step failed.

    I Have Sys admin privileges on that instance, Do i need more access? or Team\sqlserver needs anything more to execute the package?

    Team\sqlserver has these privelages:

    db_ssisoperator.

    rs_execrole

    db_ssisadmin

    db_ssisltduser

    sqlagentoperatorrole.

    sqlagentreaderrole.

    sqlagentuserrole.

    Please help its urgent. I have searched so many forums since yesterday but couldn't get enough information about it.

    Have you checked the current rights on msdb.dbo.sp_ssis_getpackage, as suggested by the error message?


  • how to check that?

  • Hmm, I'm no DBA:-) This might help:

    SELECT * FROM fn_my_permissions('msdb.dbo.sp_ssis_getpackage', 'OBJECT')

    where permission_name = 'EXECUTE'

    If it returns a row, you should have EXECUTE permission. If not, you might have to GRANT EXECUTE on it.


  • It did return a row.

    But I some how getting the error again.

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

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