I have recently moved this process from 2005 bids process to 2008. I am not sure what is going on. The job fails and posts this message:
Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 3:30:52 PM Error: 2013-08-28 15:30:53.60 Code: 0xC004706C Source: Data Flow Task SSIS.Pipeline Description: Component "component "Unpivot 1" (7952)" could not be created and returned error code 0x80070005. Make sure that the component is registered correctly. End Error Error: 2013-08-28 15:30:53.69 Code: 0xC0048021 Source: Data Flow Task Unpivot 1  Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Unpivot;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0". End Error Error: 2013-08-28 15:30:53.69 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: component "Unpivot 1" (7952) failed validation and returned error code 0xC0048021. End Error Error: 2013-08-28 15:30:53.69 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2013-08-28 15:30:53.69 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: Elapsed: 1.014 seconds. Process Exit Code 1. The step failed.
I have tried re-registering the component but no avail. I also recreated the Unpivot and I still receive the issue. I have also tried turning 'Run64BitRuntime' to false and still no luck. Any ideas?
Wrong forum. You probably should post this in the SSIS forum.
Identical problem to yours posted here. http://www.sqlservercentral.com/Forums/Topic979835-391-1.aspx Don't know if the suggestions there resolved the problem but I'd suggest going into Control Panel | Programs and Features and attempting to repair your installation from there.
<a href="http://martinsbiblog.spaces.live.com" target="_blank">http://martinmason.wordpress.com</a>
Please check if you have install SQL Server Integration Services on your machine. The error code 0x80070005 means "Access is denied", please also recheck that current account have sufficient permission access to SSIS folders.
In addition, we discuss SQL Server Analysis Services related issue in this forum. If you have any more questions about it, please post your question in SQL Server Integration Services forum for better support.
TechNet Community Support
- Edited by Elvis LongMicrosoft contingent staff, Moderator Tuesday, September 03, 2013 9:40 AM typo