issue with creating master package
Hi Team, I am trying to create master package which will call all the packages which are stored in MDSB. How to go about any link or some information would be helpful. Thanks, Eshwar.
May 16th, 2012 1:06am

You can use a script to extract all the package names and their locations from the MSDB system tables and then use an Execute Package Task inside a for each loop. http://msdn.microsoft.com/en-us/library/ms137609.aspx However, I would never design such a package. Such a master package would blindly execute whatever is on the server, and I'm not sure I would want that in production. MCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2012 5:09am

Hello, Follow the blog below. It may help you. http://www.simple-talk.com/sql/ssis/executing-ssis-packages-/
May 16th, 2012 6:17am

Team, I am getting an error while trying to select a package which is stored in SQLServer msdb. Created a connection to the msdb, using a execute package task and when trying to select the package it is throwing an error "No Description found" Any help on the issue will be helpful!! Regards, Eshwar.
Free Windows Admin Tool Kit Click here and download it now
June 15th, 2012 12:56am

it seems working the user should have permissions on the msdb db to use it as connection string in execute package task. Is there any harm in giving user the msdb access? Regards, Eshwar.
June 15th, 2012 1:48am

it seems working the user should have permissions on the msdb db to use it as connection string in execute package task. Is there any harm in giving user the msdb access? Regards, Eshwar. There are specific roles for that: Using Integration Services Roles db_ssisoperator should fit fine normally.MCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
June 15th, 2012 2:12am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics