Solved

Package Execution Error on SQL Server 2005 cluster that has failed over to the passive node

Posted on 2011-02-16
2
874 Views
Last Modified: 2012-05-11
Hello experts,
I get the below error when I run a SQL job that executes packages on SQL Server 2005 cluster that has failed over to the passive node:

Executed as user: MYT\MHGservice2. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  9:48:11 AM  Error: 2011-02-16 09:48:13.01     Code: 0xC004706C     Source: Data Flow Task DTS.Pipeline     Description: Component "component "Destination - IVRAppoint_csv" (79)" could not be created and returned error code 0x80070005. Make sure that the component is registered correctly.  End Error.  The return value was unknown.  The process exit code was -1073741819.  The step failed.

Executed as user: MYT\MHGservice2. ...0.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  9:50:54 AM  Error: 2011-02-16 09:50:55.23     Code: 0xC004706C     Source: Data Flow Task DTS.Pipeline     Description: Component "component "Destination - IVRRecall_csv" (25)" could not be created and returned error code 0x80070005. Make sure that the component is registered correctly.  End Error  Error: 2011-02-16 09:50:55.24     Code: 0xC0048021     Source: Data Flow Task Destination - IVRRecall_csv [25]     Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Flat File Destination;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0".  End Error  Error: 2011-02-16 09:50:55.24     Code: 0xC0047017     Source: Data Flow Task DTS.Pipeline  ...  The package execution fa...  The step failed.

Thoughts on how to resolve this?

Thanks!

0
Comment
Question by:robthomas09
2 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
Comment Utility
The main issue seems to be that "Destination - IVRAppoint_csv" could not be created and make sure same path and reghts/permissions exists on folders local to your SQL server as for active where hopefully this works.
0
 

Author Closing Comment

by:robthomas09
Comment Utility
We ended up having to reinstall SSIS and it worked.  Crazy.  Thanks!
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Data center mess 4 45
SQl help with selection 14 43
Updating variable table 9 16
How to find duplicates in SQL Server 3 21
The 6120xp switches seem to have a bug when you create a fiber port channel when you have a UCS fabric interconnects talking to them.  If you follow the Cisco guide for the UCS, the FC Port channel will never come up and it will say that there are n…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now