Split SSIS project in to multiple files to avoid merge hellHow to avoid log space error while executing SSIS...
Why is it that Bernie Sanders always called a "socialist"?
Is it possible to detect 100% of SQLi with a simple regex?
Is the UK legally prevented from having another referendum on Brexit?
How to compute the dynamic of stock using Geometric Brownian Motion?
Multiple null checks in Java 8
Can you say "leftside right"?
Is Developer Console going to be deprecated?
How do I fight with Heavy Armor as a Wizard with Tenser's Transformation?
Why does this quiz question say that protons and electrons do not combine to form neutrons?
What sort of grammatical construct is ‘Quod per sortem sternit fortem’?
Is the tritone (A4 / d5) still banned in Roman Catholic music?
Coworker asking me to not bring cakes due to self control issue. What should I do?
How can I prep for the Curse of Strahd adventure effectively?
Missing a connection and don't have money to book next flight
Expression for "unconsciously using words (or accents) used by a person you often talk with or listen to"?
How to Build a List from Separate Lists
Sets which are both Sum-free and Product-free.
What is an explicit bijection in combinatorics?
Are all power cords made equal?
How bad is a Computer Science course that doesn't teach Design Patterns?
Coworker is trying to get me to sign his petition to run for office. How to decline politely?
Can a Way of Shadow Monk use Shadow Step to teleport to a dark ceiling and then body slam another creature?
Identical projects by students at two different colleges: still plagiarism?
How can I handle players killing my NPC outside of combat?
Split SSIS project in to multiple files to avoid merge hell
How to avoid log space error while executing SSIS packages?Importing Excel files with SSISSQL Server split mdf into multiple filesSSIS FTP Sending Blank FilesSSIS Failed to start projectIntroduce or not introduce SSIS to an ETL projectConditionally move files in SSISExecuting SSIS Package from a stored procedure with different user privilegesHow does SSIS Balanced Data Distributor decide to split records?How to read data from multiple Excel files with SQL Server Integration Services(New Senario)
Since SSIS does not like being merged nicely I was wondering how to have a big SSIS package split up. With the idea of having multiple devs working on this simultaneously, and a minimal chance of having merge conflicts.
In SSIS 2016 I found these options:
package parts, but apparently they don't share connection managers. I don't want to have 100 different connection managers.
subpackages, still this doesn't look very clean and I also wonder if this is what it is intended for. Also, the debugger goes crazy too opening the subpackages while running. Any other drawbacks I should know of?
I can't be the only person with this problem. Is there an other way to achieve this?
sql-server ssis visual-studio development
edited May 6 '17 at 14:10
B.lahm
77
asked Jan 19 '17 at 10:47
Sam SegersSam Segers
1114
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
Since SSIS does not like being merged nicely I was wondering how to have a big SSIS package split up. With the idea of having multiple devs working on this simultaneously, and a minimal chance of having merge conflicts.
In SSIS 2016 I found these options:
package parts, but apparently they don't share connection managers. I don't want to have 100 different connection managers.
subpackages, still this doesn't look very clean and I also wonder if this is what it is intended for. Also, the debugger goes crazy too opening the subpackages while running. Any other drawbacks I should know of?
I can't be the only person with this problem. Is there an other way to achieve this?
sql-server ssis visual-studio development
edited May 6 '17 at 14:10
B.lahm
77
asked Jan 19 '17 at 10:47
Sam SegersSam Segers
1114
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
I suggest that if your package is that big then you need to work out how to logically break it into multiple packages. This doesn't help with deployment but does help with development. You can also break a package up by moving functionality into the database (i.e. calling stored procedures), and this is often faster.
– Nick.McDermaid
Jan 23 '17 at 1:35
Have you looked at BIDShelper and it's Smartdiff?
– Tom V
May 6 '17 at 12:25
add a comment |
Since SSIS does not like being merged nicely I was wondering how to have a big SSIS package split up. With the idea of having multiple devs working on this simultaneously, and a minimal chance of having merge conflicts.
In SSIS 2016 I found these options:
package parts, but apparently they don't share connection managers. I don't want to have 100 different connection managers.
subpackages, still this doesn't look very clean and I also wonder if this is what it is intended for. Also, the debugger goes crazy too opening the subpackages while running. Any other drawbacks I should know of?
I can't be the only person with this problem. Is there an other way to achieve this?
sql-server ssis visual-studio development
edited May 6 '17 at 14:10
B.lahm
77
asked Jan 19 '17 at 10:47
Sam SegersSam Segers
1114
Since SSIS does not like being merged nicely I was wondering how to have a big SSIS package split up. With the idea of having multiple devs working on this simultaneously, and a minimal chance of having merge conflicts.
In SSIS 2016 I found these options:
package parts, but apparently they don't share connection managers. I don't want to have 100 different connection managers.
subpackages, still this doesn't look very clean and I also wonder if this is what it is intended for. Also, the debugger goes crazy too opening the subpackages while running. Any other drawbacks I should know of?
I can't be the only person with this problem. Is there an other way to achieve this?
sql-server ssis visual-studio development
sql-server ssis visual-studio development
edited May 6 '17 at 14:10
B.lahm
77
asked Jan 19 '17 at 10:47
Sam SegersSam Segers
1114
edited May 6 '17 at 14:10
B.lahm
77
asked Jan 19 '17 at 10:47
Sam SegersSam Segers
1114
edited May 6 '17 at 14:10
B.lahm
77
edited May 6 '17 at 14:10
B.lahm
77
edited May 6 '17 at 14:10
B.lahm
77
77
asked Jan 19 '17 at 10:47
Sam SegersSam Segers
1114
asked Jan 19 '17 at 10:47
Sam SegersSam Segers
1114
asked Jan 19 '17 at 10:47
Sam SegersSam Segers
1114
1114
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
I suggest that if your package is that big then you need to work out how to logically break it into multiple packages. This doesn't help with deployment but does help with development. You can also break a package up by moving functionality into the database (i.e. calling stored procedures), and this is often faster.
– Nick.McDermaid
Jan 23 '17 at 1:35
Have you looked at BIDShelper and it's Smartdiff?
– Tom V
May 6 '17 at 12:25
add a comment |
I suggest that if your package is that big then you need to work out how to logically break it into multiple packages. This doesn't help with deployment but does help with development. You can also break a package up by moving functionality into the database (i.e. calling stored procedures), and this is often faster.
– Nick.McDermaid
Jan 23 '17 at 1:35
Have you looked at BIDShelper and it's Smartdiff?
– Tom V
May 6 '17 at 12:25
I suggest that if your package is that big then you need to work out how to logically break it into multiple packages. This doesn't help with deployment but does help with development. You can also break a package up by moving functionality into the database (i.e. calling stored procedures), and this is often faster.
– Nick.McDermaid
Jan 23 '17 at 1:35
I suggest that if your package is that big then you need to work out how to logically break it into multiple packages. This doesn't help with deployment but does help with development. You can also break a package up by moving functionality into the database (i.e. calling stored procedures), and this is often faster.
– Nick.McDermaid
Jan 23 '17 at 1:35
Have you looked at BIDShelper and it's Smartdiff?
– Tom V
May 6 '17 at 12:25
Have you looked at BIDShelper and it's Smartdiff?
– Tom V
May 6 '17 at 12:25
add a comment |
1 Answer
1
active
oldest
votes
I've been using subpackages successfully on multiple projects. The typical scope is one sub-package per target table. I also have a few utility packages eg Disable Indexes, Rebuild Indexes (on a table, passed as a parameter). A single "Master Control Package" is mostly Execute Package tasks.
With the Project Deployment method, devs need to be aware that prematurely checking in their changes to a single package can block the deploy (it wont deploy a project until all the packages validate cleanly).
answered Jan 22 '17 at 23:32
Mike HoneyMike Honey
24615
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
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%2fdba.stackexchange.com%2fquestions%2f161584%2fsplit-ssis-project-in-to-multiple-files-to-avoid-merge-hell%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I've been using subpackages successfully on multiple projects. The typical scope is one sub-package per target table. I also have a few utility packages eg Disable Indexes, Rebuild Indexes (on a table, passed as a parameter). A single "Master Control Package" is mostly Execute Package tasks.
With the Project Deployment method, devs need to be aware that prematurely checking in their changes to a single package can block the deploy (it wont deploy a project until all the packages validate cleanly).
answered Jan 22 '17 at 23:32
Mike HoneyMike Honey
24615
add a comment |
I've been using subpackages successfully on multiple projects. The typical scope is one sub-package per target table. I also have a few utility packages eg Disable Indexes, Rebuild Indexes (on a table, passed as a parameter). A single "Master Control Package" is mostly Execute Package tasks.
With the Project Deployment method, devs need to be aware that prematurely checking in their changes to a single package can block the deploy (it wont deploy a project until all the packages validate cleanly).
answered Jan 22 '17 at 23:32
Mike HoneyMike Honey
24615
add a comment |
I've been using subpackages successfully on multiple projects. The typical scope is one sub-package per target table. I also have a few utility packages eg Disable Indexes, Rebuild Indexes (on a table, passed as a parameter). A single "Master Control Package" is mostly Execute Package tasks.
With the Project Deployment method, devs need to be aware that prematurely checking in their changes to a single package can block the deploy (it wont deploy a project until all the packages validate cleanly).
answered Jan 22 '17 at 23:32
Mike HoneyMike Honey
24615
I've been using subpackages successfully on multiple projects. The typical scope is one sub-package per target table. I also have a few utility packages eg Disable Indexes, Rebuild Indexes (on a table, passed as a parameter). A single "Master Control Package" is mostly Execute Package tasks.
With the Project Deployment method, devs need to be aware that prematurely checking in their changes to a single package can block the deploy (it wont deploy a project until all the packages validate cleanly).
answered Jan 22 '17 at 23:32
Mike HoneyMike Honey
24615
answered Jan 22 '17 at 23:32
Mike HoneyMike Honey
24615
answered Jan 22 '17 at 23:32
Mike HoneyMike Honey
24615
answered Jan 22 '17 at 23:32
Mike HoneyMike Honey
24615
24615
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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.
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%2fdba.stackexchange.com%2fquestions%2f161584%2fsplit-ssis-project-in-to-multiple-files-to-avoid-merge-hell%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
I suggest that if your package is that big then you need to work out how to logically break it into multiple packages. This doesn't help with deployment but does help with development. You can also break a package up by moving functionality into the database (i.e. calling stored procedures), and this is often faster.
– Nick.McDermaid
Jan 23 '17 at 1:35
Have you looked at BIDShelper and it's Smartdiff?
– Tom V
May 6 '17 at 12:25