February 9, 2018 at 7:58 am
Hi,
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.
February 9, 2018 at 8:26 am
It turns out that I can get the simple package parameter example to work if my targetserverversion is set to SQL Server 2017 (an option that wasn't available before I updated my SQL server data tools). This is a bit annoying as the production server I have to work with is a SQL server 2016, so I'm not sure how well a SQL Server 2017 project will do on there.
Not sure why targetserverversion SQL Server 2016 has stopped working, sensitive project parameters was definitely available in SSDT in SQL server 2016.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply