SSIS : Deployment failed on Changing Protection Level stage with XML Error



I am using SQL Server Data Tools 2012 version and Project Deployment Model.


I am getting below error while changing Protection level stage of the Deployment on Client's Testing Environment.



The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error 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.



I have created Project parameters to provide Sharepoint Site Connection String and SQL Server Database Connection String.


( Overview of the SSIS Package : Extracting data from SharePointLists and then importing in SQL Tables.)


When I searched for this error, found many ways to set the package configurations for Package Deployment Model.


What is that thing which I am missing here in the configuration of Package, so that it is not able to encrypt decrypt the mentioned UserID and Password details ?


I have gone through many forums to get clear idea on this, but could not find any solution yet.


Is it something to do with the Integration Services Version and Deployment Utility version same on the Client environment as well ? Where exactly I should check the installed versions of them ?


The ProtectionLevel is set to : DontSaveSensitive


Please help.


Thank you,


Mittal.


No comments:

Post a Comment