SSIS: could not be created and returned error code 0x80004005 "Unspecified error"

ho ngoc phuc 1 Reputation point
2022-03-17T02:23:26.26+00:00

Hi,

I created 1 Package like to import Excel file to SQL server table by using OLE DB destination(Excel_WorkingTable Qlik Teams). But when I run the package from SQL job it failed and return to error:
" could not be created and returned error code 0x80004005 "Unspecified error". Make sure that the component is registered
correctly.

Import Qlik Team to DB:Error: Component "Excel_WorkingTable Qlik Teams, clsid

{7B729B0A-4EA5-4A0D-871A-B6E7618E9CFB}
" could not be created and returned error code 0x80004005 "Unspecified error". Make sure that the component is registered correctly.
Import Qlik Team to DB:Error: Excel_WorkingTable Qlik Teams failed initialization and returned error code 0x800703FA.
Import Qlik Team to DB:Error: There were errors during task validation.

Is there any one has solution for it
Thank you

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,400 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,459 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,286 Reputation points
    2022-03-17T08:01:52.7+00:00

    Hi@ho ngoc phuc ，

    Please help check that if you run the package via VS, will it work or not?

    If it could work in VS but fail in agent job, ensure that the service account configured to run the job have access to OLE DB destination(Excel_WorkingTable Qlik Teams).

    Besides, you could try to switch the run mode to 32/64 bit and using Proxy account to execute the package.

    Refence: how-do-i-troubleshoot-ssis-packages-failed-execution-in-a-sql-agent-job

    You may search the clsid {7B729B0A-4EA5-4A0D-871A-B6E7618E9CFB} in registry editor and check Component Services (start-Administrative Tools ->Components Services->Computers->my computer->DCOM Config), located the app and check properties->security, add NetWORK Service account and give it the launch and activate permissions.

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments