2005 & 2008 SSIS Packages

Posted on 2009-02-12
Last Modified: 2013-11-30
I know in 2000 I cannot setup a user to only be able to execute and modify only certain DTS packages.  It is either all of them or none of them.  With SQL Server 2005 or 2008 in SSIS is it possible to do this?
Question by:N R
    LVL 8

    Expert Comment

    I dont know about user based permissions. But you can set passwords on the packages and share it with only the users that should get access on them
    LVL 11

    Author Comment

    by:N R
    Well what do you mean users that get access on them?  So I can say that user test can only access these SSIS packages but not others?
    LVL 15

    Expert Comment

    I don't think there any option grant the access to perticular SSIS package(s) to one or more logins but you can create a procedure with the option EXECUTE AS  using xp_cmdshell and dtexec to execute ssis package and GRANT the execute permissions to the user.

    LVL 42

    Accepted Solution


    Integration Services includes the three fixed database-level roles db_dtsadmin, db_dtsltduser, and db_dtsoperator for controlling access to packages
    Security Considerations for Integration Services
    execution you may try to control via sqlagent jobs for SSIS pack
    access you may try to control by placing SSIS pack in folders witj NTFS permissions for specific users

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now