I have an issue where I am using SQL Server Data Tools 14.0.1016.232. i am using encrypt sensitive with password on the package and the project. When I make a sensitive package parameter, then whenever I execute any task in the package, it says the following:
Exception deserializing the package "The package failed to load due to erro 0xC0011008 "error loading from XML. No further information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.
If I change the parameter from a sensitive parameter to a normal parameter, the package can run again when I execute the package.
Has anyone experienced this before, and do they have any suggestions on fixing it? It seems like it was recently the sensitive dropdown has broken, as packages that I had made in the past that were working with no issue, now only work if I uncheck the sensitive box on the parameters.
Edit: Sensitive project parameters works with no issue, just something odd going on with sensitive package parameters.
Edit 2: This happens on an extremely simplified case. New solution, new project. One dataflow, one package parameter set to sensitive. Execute empty data flow fails when sensitive.