Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SSIS Child Packages get opened when being executed.

Posted on 2016-09-22
2
Medium Priority
?
109 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
Megan Brooks earned 2000 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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

This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses

715 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