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