Solved

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

Posted on 2011-02-16
2
881 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 34908280
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
ID: 34916918
We ended up having to reinstall SSIS and it worked.  Crazy.  Thanks!
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

739 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