I have created a package in SSIS, which executes in Visual Studio. When I create a job and schedule the package I get this error (below). Can anyone decipher this mess for me and tell me which steps to take to get the schedule working?
Executed as user: NT AUTHORITY\NETWORK SERVICE. ...00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:50:24 AM Error: 2007-10-01 10:50:24.98 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 Progress: 2007-10-01 10:50:55.51 Source: Data Flow Task Validating: 0% complete End Progress Error: 2007-10-01 10:50:55.71 Code: 0xC0047062 Source: Data Flow Task Source - Query  Description: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at Sys... The package execution fa... The step failed.