I moved a db from a 32 bit SQL install to a 64 bit SQL install. We have
re****ts that ****t data using DTS in to an Excel spreadsheet. Since moving
the db these are not working with the below error:
Executed as user: GSB\sqladmin2000. ...n 9.00.3042.00 for 64-bit
Copyright
(C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:52:00 PM
Error: 2008-02-01 16:52:00.60 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: 2008-02-01 16:52:00.96 Source: Copy Data from Results to
Sent
Task Validating: 0% complete End Progress Progress: 2008-02-01
16:52:00.96 Source: Copy Data from Results to Sent Task
Validating:
33% complete End Progress Error: 2008-02-01 16:52:01.28 Code:
0xC0202009 Source: Survey Returned Weekly Connection manager
"Connection
2" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has
occurred. Error code... Process Exit Code 1. The step failed.
My DBA seems to think this is occurring because the driver is not listed
in
the Drivers tab of the ODBC dialog box. I find the actual driver needed
in
the SysWOW64 subdirectory. How can I get this to work? Will installing
Excel resolve this issue?
Thank you.
