Solved

SSIS Child Packages get opened when being executed.

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Expressions are in essence, code. If you had an expression 2 + 2 it would evaluate to 4. A string expression of “Hello” + “ “ + “World” would evaluate to “Hello World”. Expressions are an excellent choice for working with dynamic variables, espec…
In a previous article I've shown you how to import data from an Excel sheet using the OPENROWSET() function (http://www.experts-exchange.com/A_3025.html).  And I concluded by stating that it's not the best option when automating your data import. …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

770 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