September 2, 2010 at 1:01 pm
Hi,
I have a SSIS package that uses UNPIVOT component. If i execute the package, it executes fine but if I schedule it as a SQL agent job it does not execute the package and gives the following error message:
Error: 2010-09-02 14:53:49.02 Code: 0xC004706C Source: Data Flow Task SSIS.Pipeline Description: Component "component "Unpivot" (85)" could not be created and returned error code 0x80070005. Make sure that the component is registered correctly. End Error
Code: 0xC0048021 Source: Data Flow Task Unpivot [85] 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
Does any one have any idea as what do I need to do to register the component. Thanks!
September 2, 2010 at 2:10 pm
I wouldn't recommend attempting to manually fix this issue - run through the SQL Installer and "repair" the installation.
Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components
September 3, 2010 at 6:34 am
That didn't fix anything. Any other ideas? Please help.
September 8, 2010 at 9:22 am
Please provide some more details on your setup. List the name (or just refer to it as DEV) of your development machine, OS version/bitness, SQL version/bitness. Please do the same for any servers you happen to have in this scenario.
Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components
September 8, 2010 at 11:31 am
Try to register the component manually.
For SQL2008
Start->Run
regsvr32 "C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents\TxUnPivot.dll"
For SQL2005
Start->Run
regsvr32 "C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents\TxUnPivot.dll"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply