March 19, 2023 at 9:14 pm
Hi Everyone
I am working on a SSIS package. There are multiple steps in the SSIS package design so I created 5 different SSIS packages - one for each step. Now, I want to put them all in one SSIS package. I created a new master SSIS and intend to copy and paste all the components from the step SSIS packages. I can copy over the components no problem but in the master SSIS it is saying that the connection manager cannot be found:
Error at Package: The connection "{C7747C92-C461-4EC7-8566-6259DB6CCE57}" is not found. This error is thrown by Connections collection when the specific connection element is not found.Does anyone have any ideas on how I can fix this? The SSIS packages work for each step but seems like when they are put together there is a conflict or something that is causing issues.
Thank you
March 19, 2023 at 10:03 pm
Having a single, multifunctional behemoth package is generally regarded as bad practice. Better to add five execute package tasks to your master package rather than copy everything in.
If these child packages are referencing common connections, those connections should be promoted to 'project' connections. Such connections can be shared by packages in the project.
Package level connections are specific to a package and have their own GUIDs, which are different, even if they are configured identically, which explains your error.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 27, 2023 at 7:35 am
This was removed by the editor as SPAM
March 27, 2023 at 8:04 am
This was removed by the editor as SPAM
March 28, 2023 at 7:36 am
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply