Failed To Apply Package Protection With Error 0xc0014061
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: The system could not verify that the destination supports secure storage capability SQL Server > SQL Server Integration Services Question 0 Sign in to vote I am trying to save my package (usingMS Visual Studio)with ProtectionLevel = ServerStorage but it is failing with the following error "failed to apply package protection 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...". I am trying to test a scenario on which the package is saved in SQL Server/msdb and schedule the package via SQL Job Agent. Can someone show me how to save a package using serverstorage and schedule it via SQL Job Agent?TIA,Lito Thursday, October 27, 2005 6:26 PM Reply | Quote Answers 0 Sign in to vote Here is how it can be done:1. Click on the work flow of the package you want to export to MSDB2. From the menuchooseFile --> Save Copy of your-pkg.dtsx As...3. Fill out Save Copy of Package dialog and make sure the protection level set to "Rely on server storage and roles for access control"There are other ways to do it but it will require first to save your package on the File System using a different protection level. Then you can use DTUtil or SSMS to export the package to MSDB. Friday, November 04, 2005 1:51 AM Reply | Quote All replies 0 Sign in to vote Here is how it can be done:1. Click on the work flow of the package you want to export to MSDB2. From the menuchooseFile --> Save Copy of your-pkg.dtsx As...3. Fill out Save Copy of Package dialog and make sure the protection level set to "Rely on server storage and roles for access control"There are other ways to do it but it will require first to save your package on the File System using a different protection level. Then you can use DTUtil or SSMS to export the package to MSDB. Friday, November 04, 2005 1:51 AM Reply | Quote 0 Sign in to vote I have not option to change the protection level when Iam "saving as".It simply saves a ne
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2008 Forums SSIS and Import/Export (2008) Package configuration error & SQL authentication Reply to Topic Printer Friendly Author https://social.msdn.microsoft.com/Forums/sqlserver/en-US/40d7b04b-f7e6-49f1-83bb-7b72d8453ab6/the-system-could-not-verify-that-the-destination-supports-secure-storage-capability?forum=sqlintegrationservices Topic BaconPopper Starting Member Belgium 7 Posts Posted-09/23/2010: 11:33:32 Hi,I have a simple package which read from SQL Server and loads into a flatfile.The OLE DB source connection uses SQL authetication.I set up package configurations with XML to store the credentials of the OLE DB connection.The value for the password is empty the first time, but when I put http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=150559 the password in the config file, my package runs without any problem.If I do the same but store the configuration info in a SQL table (which is stored in the same DB as the one i'm going to read the data from), my package won't work stating that he can't login.If I check the config table, everything is set-up correctly though (including the password)Anyone who know's a solution for this problem?grts visakh16 Very Important crosS Applying yaK Herder India 52326 Posts Posted-09/23/2010: 13:40:47 whats the protection level set for the package?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ BaconPopper Starting Member Belgium 7 Posts Posted-09/24/2010: 03:43:07 It's set to DonSaveSensitive, as it is supposed to be. BaconPopper Starting Member Belgium 7 Posts Posted-09/28/2010: 04:55:06 nobody who had the same problem before?or does everybody uses integrated security when deploying solutions at clients? russell Pyro-ma-ni-yak USA 5072 Posts Posted-09/28/2010: 13:52:26 i always use rely on server storage and roles BaconPopper Starting Member Belgium 7 Posts Posted-09/29/2010: 04:14:03 that doesn't work at all when using configurations russell Pyro-ma-ni-yak USA 5
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help https://www.experts-exchange.com/questions/25860545/Exporting-SSIS-Package-Programmatically.html Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services http://www.networksteve.com/enterprise/topic.php/Deploy_SSIS_via_a_Job/?TopicId=55331&Posts=15 Groups Website Testing Store Headlines Experts Exchange > Questions > Exporting SSIS Package Programmatically Want to Advertise Here? Solved Exporting SSIS Package Programmatically Posted on 2010-04-13 MS SQL Server 1 Verified Solution 5 Comments 1,027 Views Last Modified: 2013-11-30 Hello, I'm trying to create copies of all ssis packages in MSDB folder and copy them to a directory failed to in windows. I'm currently using the SaveToXML method to copy the ssis package, but I'm getting the following error: Failed to apply package protection 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.". This error occurs when saving to Xml. The code I'm using is below. Imports System Imports System.Text Imports Microsoft.SqlServer.Dts.Runtime failed to apply Imports Microsoft.SqlServer.Dts.Tasks.BulkInsertTask Public Class ScriptMain Public Sub Main() Dim sqlFolder As String Dim sqlServer As String Dim ssisApplication As Application Dim sqlPackages As PackageInfos Dim sqlPackage As PackageInfo Dim Packg As New Package Dim NewFileName As String Dim SSISName As String sqlServer = "SERVERNAME" ssisApplication = New Application() ' Get packages stored in MSDB. sqlFolder = "MSDB/CSRT_SSIS_CONVERSION" sqlPackages = ssisApplication.GetDtsServerPackageInfos(sqlFolder, sqlServer) If sqlPackages.Count > 0 Then Dts.Events.FireInformation(0, "Packages stored in " & sqlFolder & ":", Nothing, String.Empty, 0, False) For Each sqlPackage In sqlPackages Console.WriteLine(sqlPackage.Name) Dts.Events.FireInformation(0, sqlPackage.Name, Nothing, String.Empty, 0, False) NewFileName = "D:\SSISSaveFiles\" & sqlPackage.Name & ".dtxs" SSISName = sqlFolder & "\" & sqlPackage.Name Pa
Job step with Type: SQL Server Integration Services Package Run as: SQL Server Agent Service Account For Package source I have tried a few options. When I use SQL Server I can not see the package to select it. When I use File system and put the path in I get the following error when I run it. Executed as user: SQL1\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 3:41:21 PM Error: 2012-05-14 15:41:21.03 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2012-05-14 15:41:21.14 Code: 0xC0202009 Source: CHRobinson Connection manager "SQL1.M2MDATA01.sa" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'sa'.". End Error Error: 2012-05-14 15:41:21.14 Code: 0xC00291EC Source: Execute SQL Task Execute SQL Task Description: Failed to acquire connection "SQL1.M2MDATA01.sa". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:41:21 PM Finished: 3:41:21 PM Elapsed: 0.156 seconds. The package execution failed. The step failed. May 14th, 2012 4:12pm You need to change the package protection to Rely on Server for StorageArthur My Blog Free Windows Admin Tool Kit Click here and download it now May 14th, 2012 4:20pm How did you set Protection Level? you can use SaveSensitiveWithPassword, or RelyOnServerStorage as Arthur said, this link shows how to set protection level of package when you want to deploy: http://www.mssqltips.com/sqlservertip/2091/securing-your-ssis-packages-using-package-protection-level/http://www.rad.pasfu.com May 14th, 2012 4:24pm When I change it to that and tried to save I get an error: Failure saving package. Additional information: failed to apply package protection 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.". This error occu