SSIS: How to find the parent of a given package?
0
I have an SSIS Project with about 100 packages, and it's difficult to find the execution order of it all. I don´t even know which one is the master package. That being said, my question is: Given a package, is there a way to determine where that particular package is being called? Or in other words, what is the precedence of that package?
sql-server ssis asked Nov 14 '18 at 17:32
Lina SilveiraLina Silveira
85
add a comment |
0
I have an SSIS Project with about 100 packages, and it's difficult to find the execution order of it all. I don´t even know which one is the master package. That being said, my question is: Given a package, is there a way to determine where that particular package is being called? Or in other words, what is the precedence of that package?
sql-server ssis asked Nov 14 '18 at 17:32
Lina SilveiraLina Silveira
85
What do you mean here? Packages in SSIS don't have a hierarchy structure; they all belong to a project. They don't have a "parent". I'm assuming that you mean that some packages aren't directly called and are called via the SSIS Package Task from another? Have you consulted your company's documentation on the packages? That should tell you what package is called by what (and what they do). If not, there's no easy way to find out. Either you'll need to open your packages and inspect any SSIS Package tasks, or otherwise you could inspect the XML.
– Larnu
Nov 14 '18 at 17:38
What version of SSIS are you working with? If 2012+, are they using the Project Deployment Model (SSISDB)?
– billinkc
Nov 14 '18 at 17:48
The most common route for running a child package will be the existence of anExecute Package Taskbut you could be looking for anExecute SQL Taskas they might want to run a package in asynchronous mode. They might also launch the child package using .NET so aScript Taskwould need to be inspected. The next challenge in finding order is how the orchestrator package determines said order. If you're lucky, it's serial execution (Execute Package Task 1 -> EPT 2 -> ... EPT x) My pattern looks at a table to determine package dependency and then uses Foreach Loop Container to run packages
– billinkc
Nov 14 '18 at 17:54
1
@Larnu , Parent-child is a name of a design pattern that consists of packages executing other packages. One package can execute another package through the use of one of the following:*The Execute Package Task, *T-SQL commands, The Execute Process Task (using the dtexec.exe utility). Source [link] (timmitchell.net/post/2014/02/07/parent-child-ssis-architecture)
– Lina Silveira
Nov 15 '18 at 9:01
add a comment |
0
0
0
I have an SSIS Project with about 100 packages, and it's difficult to find the execution order of it all. I don´t even know which one is the master package. That being said, my question is: Given a package, is there a way to determine where that particular package is being called? Or in other words, what is the precedence of that package?
sql-server ssis asked Nov 14 '18 at 17:32
Lina SilveiraLina Silveira
85
I have an SSIS Project with about 100 packages, and it's difficult to find the execution order of it all. I don´t even know which one is the master package. That being said, my question is: Given a package, is there a way to determine where that particular package is being called? Or in other words, what is the precedence of that package?
sql-server ssis sql-server ssis asked Nov 14 '18 at 17:32
Lina SilveiraLina Silveira
85
asked Nov 14 '18 at 17:32
Lina SilveiraLina Silveira
85
asked Nov 14 '18 at 17:32
Lina SilveiraLina Silveira
85
asked Nov 14 '18 at 17:32
Lina SilveiraLina Silveira
85
asked Nov 14 '18 at 17:32
Lina SilveiraLina Silveira
85
85
What do you mean here? Packages in SSIS don't have a hierarchy structure; they all belong to a project. They don't have a "parent". I'm assuming that you mean that some packages aren't directly called and are called via the SSIS Package Task from another? Have you consulted your company's documentation on the packages? That should tell you what package is called by what (and what they do). If not, there's no easy way to find out. Either you'll need to open your packages and inspect any SSIS Package tasks, or otherwise you could inspect the XML.
– Larnu
Nov 14 '18 at 17:38
What version of SSIS are you working with? If 2012+, are they using the Project Deployment Model (SSISDB)?
– billinkc
Nov 14 '18 at 17:48
The most common route for running a child package will be the existence of anExecute Package Taskbut you could be looking for anExecute SQL Taskas they might want to run a package in asynchronous mode. They might also launch the child package using .NET so aScript Taskwould need to be inspected. The next challenge in finding order is how the orchestrator package determines said order. If you're lucky, it's serial execution (Execute Package Task 1 -> EPT 2 -> ... EPT x) My pattern looks at a table to determine package dependency and then uses Foreach Loop Container to run packages
– billinkc
Nov 14 '18 at 17:54
1
@Larnu , Parent-child is a name of a design pattern that consists of packages executing other packages. One package can execute another package through the use of one of the following:*The Execute Package Task, *T-SQL commands, The Execute Process Task (using the dtexec.exe utility). Source [link] (timmitchell.net/post/2014/02/07/parent-child-ssis-architecture)
– Lina Silveira
Nov 15 '18 at 9:01
add a comment |
What do you mean here? Packages in SSIS don't have a hierarchy structure; they all belong to a project. They don't have a "parent". I'm assuming that you mean that some packages aren't directly called and are called via the SSIS Package Task from another? Have you consulted your company's documentation on the packages? That should tell you what package is called by what (and what they do). If not, there's no easy way to find out. Either you'll need to open your packages and inspect any SSIS Package tasks, or otherwise you could inspect the XML.
– Larnu
Nov 14 '18 at 17:38
What version of SSIS are you working with? If 2012+, are they using the Project Deployment Model (SSISDB)?
– billinkc
Nov 14 '18 at 17:48
The most common route for running a child package will be the existence of anExecute Package Taskbut you could be looking for anExecute SQL Taskas they might want to run a package in asynchronous mode. They might also launch the child package using .NET so aScript Taskwould need to be inspected. The next challenge in finding order is how the orchestrator package determines said order. If you're lucky, it's serial execution (Execute Package Task 1 -> EPT 2 -> ... EPT x) My pattern looks at a table to determine package dependency and then uses Foreach Loop Container to run packages
– billinkc
Nov 14 '18 at 17:54
1
@Larnu , Parent-child is a name of a design pattern that consists of packages executing other packages. One package can execute another package through the use of one of the following:*The Execute Package Task, *T-SQL commands, The Execute Process Task (using the dtexec.exe utility). Source [link] (timmitchell.net/post/2014/02/07/parent-child-ssis-architecture)
– Lina Silveira
Nov 15 '18 at 9:01
What do you mean here? Packages in SSIS don't have a hierarchy structure; they all belong to a project. They don't have a "parent". I'm assuming that you mean that some packages aren't directly called and are called via the SSIS Package Task from another? Have you consulted your company's documentation on the packages? That should tell you what package is called by what (and what they do). If not, there's no easy way to find out. Either you'll need to open your packages and inspect any SSIS Package tasks, or otherwise you could inspect the XML.
– Larnu
Nov 14 '18 at 17:38
What do you mean here? Packages in SSIS don't have a hierarchy structure; they all belong to a project. They don't have a "parent". I'm assuming that you mean that some packages aren't directly called and are called via the SSIS Package Task from another? Have you consulted your company's documentation on the packages? That should tell you what package is called by what (and what they do). If not, there's no easy way to find out. Either you'll need to open your packages and inspect any SSIS Package tasks, or otherwise you could inspect the XML.
– Larnu
Nov 14 '18 at 17:38
What version of SSIS are you working with? If 2012+, are they using the Project Deployment Model (SSISDB)?
– billinkc
Nov 14 '18 at 17:48
What version of SSIS are you working with? If 2012+, are they using the Project Deployment Model (SSISDB)?
– billinkc
Nov 14 '18 at 17:48
The most common route for running a child package will be the existence of an
Execute Package Task but you could be looking for an Execute SQL Task as they might want to run a package in asynchronous mode. They might also launch the child package using .NET so a Script Task would need to be inspected. The next challenge in finding order is how the orchestrator package determines said order. If you're lucky, it's serial execution (Execute Package Task 1 -> EPT 2 -> ... EPT x) My pattern looks at a table to determine package dependency and then uses Foreach Loop Container to run packages– billinkc
Nov 14 '18 at 17:54
The most common route for running a child package will be the existence of an
Execute Package Task but you could be looking for an Execute SQL Task as they might want to run a package in asynchronous mode. They might also launch the child package using .NET so a Script Task would need to be inspected. The next challenge in finding order is how the orchestrator package determines said order. If you're lucky, it's serial execution (Execute Package Task 1 -> EPT 2 -> ... EPT x) My pattern looks at a table to determine package dependency and then uses Foreach Loop Container to run packages– billinkc
Nov 14 '18 at 17:54
1
1
@Larnu , Parent-child is a name of a design pattern that consists of packages executing other packages. One package can execute another package through the use of one of the following:*The Execute Package Task, *T-SQL commands, The Execute Process Task (using the dtexec.exe utility). Source [link] (timmitchell.net/post/2014/02/07/parent-child-ssis-architecture)
– Lina Silveira
Nov 15 '18 at 9:01
@Larnu , Parent-child is a name of a design pattern that consists of packages executing other packages. One package can execute another package through the use of one of the following:*The Execute Package Task, *T-SQL commands, The Execute Process Task (using the dtexec.exe utility). Source [link] (timmitchell.net/post/2014/02/07/parent-child-ssis-architecture)
– Lina Silveira
Nov 15 '18 at 9:01
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53305823%2fssis-how-to-find-the-parent-of-a-given-package%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53305823%2fssis-how-to-find-the-parent-of-a-given-package%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What do you mean here? Packages in SSIS don't have a hierarchy structure; they all belong to a project. They don't have a "parent". I'm assuming that you mean that some packages aren't directly called and are called via the SSIS Package Task from another? Have you consulted your company's documentation on the packages? That should tell you what package is called by what (and what they do). If not, there's no easy way to find out. Either you'll need to open your packages and inspect any SSIS Package tasks, or otherwise you could inspect the XML.
– Larnu
Nov 14 '18 at 17:38
What version of SSIS are you working with? If 2012+, are they using the Project Deployment Model (SSISDB)?
– billinkc
Nov 14 '18 at 17:48
The most common route for running a child package will be the existence of an
Execute Package Taskbut you could be looking for anExecute SQL Taskas they might want to run a package in asynchronous mode. They might also launch the child package using .NET so aScript Taskwould need to be inspected. The next challenge in finding order is how the orchestrator package determines said order. If you're lucky, it's serial execution (Execute Package Task 1 -> EPT 2 -> ... EPT x) My pattern looks at a table to determine package dependency and then uses Foreach Loop Container to run packages– billinkc
Nov 14 '18 at 17:54
1
@Larnu , Parent-child is a name of a design pattern that consists of packages executing other packages. One package can execute another package through the use of one of the following:*The Execute Package Task, *T-SQL commands, The Execute Process Task (using the dtexec.exe utility). Source [link] (timmitchell.net/post/2014/02/07/parent-child-ssis-architecture)
– Lina Silveira
Nov 15 '18 at 9:01