rtumaykin / ssis-build

A set of utilities that allow to autonomously build a Visual Studio SSIS project (dtproj) into a deployment package (ispac), and deploy the package to an SSIS catalog
Apache License 2.0
52 stars 39 forks source link

Incorrect expression to sensitive property remove with protectionLevel = DontSaveSensitive #44

Open MelnikovIG opened 4 years ago

MelnikovIG commented 4 years ago

Assume we have expression to property: <property dataType="System.String" expressionType="Notify" name="password" Sensitive="1"></property>

When i am building my project with ssisbuild, this expression is removed. Possible place where this is happen: https://github.com/rtumaykin/ssis-build/blob/dac34b52395efc2a40e6ec901d2f254d6880a136/src/SsisBuild.Core/ProjectManagement/ProjectFile.cs#L159-L160

But this behaviour is different what VisualStudio does! Visual studio didn't remove expressions to sensitive properties even with protectionLevel = DontSaveSensitive. So this package became broken, and when you try to use it on SSISDB, you package will not assign this parameter.