I'm receiving an error on a newly upgraded SSIS package from 2005 to 2008 R2. The error happens withing an ActiveX script that fails in debug mode in BIDS (no error message described) and also in SQL Agent when I execute the job that runs the SSIS package. I keep getting the message shown below:
Executed as user: CYNDATA\mssqladmin. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:15:50 AM Error: 2012-09-07 11:15:51.71 Code: 0xC00291B1 Source: ActiveX Script Task SendTransactions ActiveX Script Task Description: User script threw an exception: "Error Code: 0 Error Source= ADODB.Connection Error Description: Provider cannot be found. It may not be properly installed. Error on Line 22 ". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:15:50 AM Finished: 11:15:51 AM Elapsed: 0.92 seconds. The package execution failed. The step failed.
I have found some information about it being an MDAC issue, but I'm not sure what the problem is as this never happened on our SQL 2005 prod environment. I need to get this fixed ASAP as this will be a showstopper for a server migration this Sunday. Any help or assitance would be greatly apprecited!!!