I have a simple Package on integration Services and a get this error when I try to execute:
11/25/2009 15:55:04,prueba,Error,1,PLANNING,prueba,Prueba,,Executed as user: NT AUTHORITY\NETWORK SERVICE. ...00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 03:55:04 p.m. Error: 2009-11-25 15:55:05.34 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: 2009-11-25 15:55:36.46 Code: 0xC0202009 Source: ContractorTemplate Connection manager "10.160.8.160.Planning.sa" Description: SSIS Error Code DTSEOLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'sa'.". End Error Error: 2009-11-25 15:55:36.46 Code: 0xC020801C Source:
I think I have to asign a password to the pakage in order to work but I dont know where is this option in the IS develpment.