Solved

SSIS Child Packages get opened when being executed.

Posted on 2016-09-22
2
58 Views
Last Modified: 2016-09-22
Hi Guys,

I have number of SSIS packages and one wrapper package that executes all the packages. When i run the wrapper package all the child packages get open when being executed.
Is there anyway to stop this happening as the number of packages are quite large and it is very irritating. I am using SSDT 2015 and SQL Server 2014

regards,
0
Comment
Question by:shah36
2 Comments
 
LVL 14

Accepted Solution

by:
Megan Brooks earned 500 total points
ID: 41810907
I gather that you are running from the SSDT GUI, and that the packages are opening for editing in the GUI. If you publish them to and run them from the SSIS Catalog, or if you execute them directly using dtexec.exe, they will not open for editing.

Configuring for execution under the SSIS Catalog (SSISDB) or using dtexec can be quite non-trivial, so to speak, depending on the requirements of your application, but these are solid, stable ways to run packages, unattended and repeatedly, in production.

Because the designer GUI shows execution progress for each child package, I doubt that you can prevent it from opening them. I never tried -- I use the designer for development, debugging, and one-off executions.

It has been a while since I have worked with SSISDB, and much longer since I have worked with dtexec, but I would be more than willing to pull them out and refresh my memory, if you need additional information. My availability for the rest of this week, however, is limited.
0
 

Author Closing Comment

by:shah36
ID: 41810988
Hi Mega,

Yes i am running the procedures from SSIS GUI, as these packaged are only for testing purposes so they will not be deployed to the server.

I thought there might be come SSIS GUI configuration to prevent this.

Anyway thanks a lot for your help.

regards,
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question