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… (0 comment)

If you create multiple packages in a Project, SQLServer Business Intelligence will not sort them based on file name.  There is an alternate way to sort the items in the way you need. Open .dtproj file in Notepad / Notepad ++  Scroll down to <DTSPackages> Example :  <DTSPackages>     <DtsPackage>           <Name>20-Export-To-Production.dtsx</Name>… (0 comment)