November 19, 2013 at 11:57 am
I've copied SSIS packages from 2005 MSDB to a folder. THen I opend SDT in 2012 and copied package from folder to SDT to do the upgrade. I double clicked the package, it says package upgraded. But when I try to save the package in SDT it spits out the following message....
Any help would be greatly appreciated.
Failure Saving Package
Failed to apply package protection with error 0xC0014061. The protection level, ServerStorage, Cannot be used when saving to this destination. They system could not verify that the destination supports secure storage capability. This error occurs when saving to XML.
November 19, 2013 at 12:24 pm
When I try to execute from SDT also, it throws the same error.
November 19, 2013 at 1:41 pm
From DTS, when I try to upgrade, here is the error.
Anybody? I am at a hard stop.
Package Upgrade: Failed to save package file "c:\users\documents\visual studio 2010\projects\SSISMigration\SSISMigration\SSIS_Package1_F.dtsx" with error 0xC0014061 "The protection level, ServerStorage, cannot be used when saving to this destination. The system could not verify that the destination supports secure storage capability.".
November 20, 2013 at 6:28 am
Have you tired changing the package protecion level within the package in SSDT:
http://technet.microsoft.com/en-us/library/cc879310.aspx
MCITP SQL 2005, MCSA SQL 2012
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply