Solved

SSIS Child Packages get opened when being executed.

Posted on 2016-09-22
2
78 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 15

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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Suggested Solutions

Title # Comments Views Activity
Help with SQL syntax please.. 10 134
SSIS Best Practices 3 114
SSIS how to COMPARE a data column from different servers? 6 140
Help with Merge Join and Conditional Split in SSIS 6 134
Over the last 2 years, I have been working on SSIS 2008. Really the tough tasks in SSIS are to deploy packages and pass parameters (Values from outside package). The latter is certainly a headache for developers, particularly for me. We had to ma…
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

734 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