Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS package error in SQL 2008 ActiveX Script


SSIS package error in SQL 2008 ActiveX Script

Author
Message
davidsalazar01
davidsalazar01
SSC Veteran
SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)

Group: General Forum Members
Points: 205 Visits: 358
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



Orlando Colamatteo
Orlando Colamatteo
SSCrazy Eights
SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)

Group: General Forum Members
Points: 8231 Visits: 14368
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search