• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 157
  • Last Modified:

SSIS Child Packages get opened when being executed.

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
Ali Shah
Asked:
Ali Shah
1 Solution
 
Megan BrooksSQL Server ConsultantCommented:
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
 
Ali ShahSQL DeveloperAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now