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