Permissions Required for Executing Child SSIS Packages

Posted Wednesday, November 8, 2006 9:27 AM by C-Dog's .NET Tip of the Day
When you have a package that executes another package with the execute package task, you have to specfiy a connection string to the SQL Server. Often times you just use the same connection that you are already using for your data. If you are storing your packages in MSDB, if you don't have permissions set up correctly, you might get a Cannot execute stored procedure. Permission Denied. error. This is easy enough to resolve, you just need to grant execute access to your account in the MSDB database for the associated DTS stored procedures. Instead of granint them manually, you can simply add the use to the dts_operator role and you will have all of the correct permissions.

Read the complete post at