Save and Schedule SSIS Packages using SQL Server 2008 R2 for Nonadmins

How to Save and Schedule SSIS Packages using SQL Server 2008 R2 for Non Administrators

Step 1

Upgrade SQLServer 2008 R2 with latest SP

Step 2

Saving Package from Business Intelligence (.dtsx) to SQL Server

EXEC sp_addrolemember 'db_ssisltduser', '<<user/group>>'

EXEC sp_addrolemember 'SQLAgentUserRole', '<<user/group>>'

Step 3

Follow this step for Connecting to a Remote Integration Services Server

http://msdn.microsoft.com/en-us/library/aa337083(v=sql.105).aspx

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.