Sample Header Ad - 728x90

Split SSIS project in to multiple files to avoid merge hell

2 votes
1 answer
665 views
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?
Asked by Sam Segers (129 rep)
Jan 19, 2017, 10:47 AM
Last activity: Aug 5, 2025, 06:05 AM