Non-sysadmin permissions to create or edit an SSIS package

Questions: How can I allow non-sysadmin user  to create and edit a SSIS package? Are special permissions required?

Answer:Any user  with Business Intelligence Developer Studio( BIDS)  can create or edit an SSIS package.   The permissions are required  to deploy the SSIS package to a SQL server.

A suitable msdb role is the db_ssisltduser role. This role allows:

READ functions

Enumerate own packages.

Enumerate all packages.

View own packages.

Execute own packages.

Export own packages.

WRITE functions

 Import packages.

Delete own packages.

This is a sample T-SQL script assigning the role to a database user

USE [master]
GO
CREATE LOGIN [mydomain\mylogon] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
USE [msdb]
GO
CREATE USER [mydomain\mylogon] FOR LOGIN [mydomain\mylogon]
GO
USE [msdb]
GO
ALTER ROLE [db_ssisltduser] ADD MEMBER [mydomain\mylogon]
GO

Read More

 View DTS packages with Powershell – DTS to SSIS planning

How to Convert Microsoft Word Format to HTML using Powershell

SQL Server 2012 SSIS upgrade considerations - SQL Server DBA