How do I change an SSIS Package ProtectionLevel to ServerStorage
Thanks.
SSIS Package ProtectionLevel
Hot Topic
- RDL vs RDLC
- Strings as measure
- Trouble with MS SQL 2000 Reporting Services
- Pivot Issues
- Sql EX 05 can't view dB and Tables
- MS Access & SQL Server 2005
- Processing a cube on SQL server 2005 from a dts package on SQL server 2000
- insert statement
- Instructions for setting up a Sybase ASE Server as a SQL Server 2005 Linked Server?
- where can I download SQL 2005 Beta 9.00.0852
SQL Server
- How I can start SQL Manager 2005
- not able to connect to the local database with (local) as server name
- Looping through an excel spreadsheet
- Maximum number of partitions in AS2005
- Cannot compare data types of System.Int32 and System.String. Please check the data type returned by the filter expression
- sql statement: listing all values
- .Net Framework for SSRS 2005
- SQL 2005 Standard error on Windows XP Pro SP2
- Trigger on enable / disable SQL User
- raw file source avoid bad data?
SSIS Package ProtectionLevel
Dirk
How do I save to SQL Server
Thanks!
fer666
Dario_Munoz
Ok - I figured out how to change it, but I get an error when trying to save. "Failure saving package." Additional Information: "Failed to apply package protection with error 0xC0014061 "The protection level Server Storage, 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. (Package)
Please advise. Thanks.
Wilka
1. File Menu... Save Copy of [Your File Name.dtsx] As...
This action will open "Save Copy of Package" Screen
2. Specify Target Server
3. Specify Authentication Type
4. Specify Package Path (Target Folder within Integration Services)
Protection Level must be set to "Server Storage"