Database Server is SQL2008 with SP1. I created ODBC that connects to one table in the database in the server. It works fine. Then I created a SSIS package that tranfer this table's data into another table using the ODBC. When executing the SSIS , it works
fine. No problem transfering data using ODBC via SSIS.
Requirement is to use SSIS package in SQL Server job and run it from there. When the SQL job is run , it fails. Error thrown is
Executed as user: CORE\svc_prodsql1. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:42:08 PM Error: 2010-08-26
12:42:08.39 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: 2010-08-26 12:42:08.75 Code: 0xC0047062
Source: Data Flow Task ADO NET Source  Description: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft]
View Complete Post