bideveloperextensions icon indicating copy to clipboard operation
bideveloperextensions copied to clipboard

In SSIS.ResetGUID do not touch project connection managers

Open ghost opened this issue 7 years ago • 2 comments

I'm trying to get up a build environment to do some work but until I can submit a pull we need to add a check to see if the connection manager scope is package and not project.

DTSConnectionManagerScope Enum https://docs.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.dts.runtime.dtsconnectionmanagerscope?view=sqlserver-2017

ConnectionManager.Scope Property https://docs.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.dts.runtime.connectionmanager.scope?view=sqlserver-2017#Microsoft_SqlServer_Dts_Runtime_ConnectionManager_Scope

ghost avatar Aug 24 '18 02:08 ghost

foreach (ConnectionManager cm in package.Connections)
                {
                    if (cm.Scope <IS the Package enum value)
                    { 
                    AddGuid(cm.ID);
                    }

ghost avatar Aug 24 '18 02:08 ghost

Thanks for the code change. I'll leave this open so we can get this enhancement into our backlog for adding to a future release.

furmangg avatar Nov 20 '18 17:11 furmangg