Good Afternoon, I have an SSIS Package that runs successfully when i execute it manually, but when i schedule it in the SSMS i'm getting the following error " Executed as user: ADOB\SQLSERVICE. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:10:01 PM Error: 2012-07-06 12:10:02.31 Code: 0xC0014060 Source: {2ABDECFC-4DBF-4B89-9D75-24BA80F31C5B} Description: Failed to decrypt a package that is encrypted with a user key. You may not be the user who encrypted this package, or you are not using the same machine that was used to save the package. End Error Could not load package "\MSDB\PKG_ABODE_STAGING_Source_Loader" because of error 0x8009000B. Description: Failed to remove package protection with error 0x8009000B "Key not valid for use in specified state.". This occurs in the CPackage::LoadFromXML method. Source: {2ABDECFC-4DBF-4B89-9D75-24BA80F31C5B} Started: 12:10:01 PM Finished: 12:10:02 PM Elapsed: 1.326 seconds. The package could not be loaded. The step failed. I changed the protection level from Encrypt Sensitive with User Key to EncryptAllWithUserKey, but am still getting the same error.

You should have the protection level set to "Don't save sensitive" The 2 other options you mention require that it be the same user who saved the package executing it Chuck Pedretti | Magenic North Region | magenic.com

Thanks Chuck i tried that option as well and am getting the same error.

You have a password somewhere in that package. You are going to have to deploy the package to the server using server storage protection level (if you are storing in MSDB) or encrypt with password. http://msdn.microsoft.com/en-us/library/ms141747(v=sql.105).aspxRussel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008 Blog: http://www.bidn.com/blogs/RussLoski/ Twitter: @sqlmovers

Thanks Russ, this PACKAGE was developed by a different developer in SQL Server 2005 and now i migrated this PACKAGE to SQL Server 2008. Is there a way i can bypass the password thing?

while deploying the package to server, you can choose the option "rely on server storage and roles for access control" from the dropdownlist. you can check also this: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/250ad907-5ec1-4bfb-a000-4ce8dc8e89b9 regards joon

Joon when you said deploying the package to the server did you mean open SSMS , Integration service and under PACKAGES under MSDB while importing the packages?

Joon when you said deploying the package to the server did you mean open SSMS , Integration service and under PACKAGES under MSDB while importing the packages?

either you can deploy the ssis packages to sql server or execute them directly from file system. while scheduling the package with a sql job, you can choose any of these options with the correct priviledge "Run as"(shown below). of you choose SQL server Agent Service account, then it will use the user under which the sq server is running(you can see that user under services.msc). l you can deploy the package to sql server also, easiest way to enable the Save the package as ... option (Tools > Customize -> Commands Tab -> scroll down and select "File" from the list on the left, select "Save Copy of Selected Item(s) As..." from the list on the right, drag it over to the File menu, and drop it in the correct place ). it will deploy the package to sql server, and while deploying you can choose the "Rely on server storage..." option. After that, you can use Package Source as SQl server in the Package Source as shown in the above pic. regards joon

Thanks all i finally got it working.

either you can deploy the ssis packages to sql server or execute them directly from file system. while scheduling the package with a sql job, you can choose any of these options with the correct priviledge "Run as"(shown below). of you choose SQL server Agent Service account, then it will use the user under which the sq server is running(you can see that user under services.msc). l you can deploy the package to sql server also, easiest way to enable the Save the package as ... option (Tools > Customize -> Commands Tab -> scroll down and select "File" from the list on the left, select "Save Copy of Selected Item(s) As..." from the list on the right, drag it over to the File menu, and drop it in the correct place ). it will deploy the package to sql server, and while deploying you can choose the "Rely on server storage..." option. After that, you can use Package Source as SQl server in the Package Source as shown in the above pic. regards joon

Thanks Joon i did exactly the way you mentioned and am getting the same error: Message Executed as user: ADOB\SQLSERVICE. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 9:10:01 AM Error: 2012-07-09 09:10:02.65 Code: 0xC0014060 Source: {CEE6DCFE-599C-44ED-8932-452E6DFF1965} Description: Failed to decrypt a package that is encrypted with a user key. You may not be the user who encrypted this package, or you are not using the same machine that was used to save the package. End Error Could not load package "\PKG_ADOB_STAGING_Source_Loader" because of error 0x8009000B. Description: Key not valid for use in specified state. Source: Started: 9:10:01 AM Finished: 9:10:02 AM Elapsed: 1.357 seconds. The package could not be loaded. The step failed. Thanks PS: I opened the PACKAGE in BIDS and changed the PROTECTION LEVEL : SERVER STORAGE and when i tried to save it's giving me the following error: TITLE: Microsoft Visual Studio ------------------------------ 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 occurs when saving to Xml. (Package) ------------------------------ 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. (Package) ------------------------------ BUTTONS: OK ------------------------------