SSIS package error in SQL 2008 ActiveX Script

  • Hello All,

    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:

    "Message

    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!!!

    Cheers,

    David :w00t:

  • I see "for 64-bit" and "Provider cannot be found." in the error message. It could be that the OLE DB provider teh package is trying to use is 32-bit only. Try setting the package/job to execute using the 32-bit SSIS runtime (32-bit version of DTExec.exe) and see if you get a different result. You can get the 32-bit version of DTExec onto your server by installing the Management Tools Complete from the Installation media.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply