Weird error - while SSIS package execution.

Question

Hi ,

We are running packages using sql agent and using service account. Few packages failed daily with these error messages. 

But we have logic in again job step for retry. So in first attempt step failed but on retry its success.  Please let me know how to fix these error if you have same experience.

Thanks in advance.

01.dtsx

8/15/2020 5:47 AM

Sent Failure Email:Error: Executing the query "" failed with the following error: "Retrieving the COM class factory for component with CLSID {8957A18C-F62B-4A46-83FC-E8792FFD06DC} failed due to the following error: 800703fa Illegal operation attempted on a registry key that has been marked for deletion. (Exception from HRESULT: 0x800703FA).". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Answer 1

Hi SR_MCTS,

Method 1

Do not log on to the server for interactive sessions by using a service account.

Method 2

Disable the related Windows User Profile Service feature. To do this, follow these steps:

  1.Open the Group Policy editor (Gpedit.msc) on the affected server.

  2.Open the UserProfiles folder in the following path:

     Computer Configuration > Administrative Templates > System > UserProfiles

  3.Locate the Do not forcefully unload the user registry at user logoff setting.

  4.Change the setting to Enabled.

Please refer to "800703fa Illegal operation attempted on a registry key" error.

Best Regards,

Mona

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.

Answer 2

Hi Mona,

Thanks for your suggestions. Could you please share more details and steps for method 1 .

Answer 3

Hi SR_MCTS,

Please check if the service account has the correct permission to the

COM class factory for component {8957A18C-F62B-4A46-83FC-E8792FFD06DC}

We can create new proxy account to execute the package.

Please refer to To automate package execution by using SQL Server Agent.

Best Regards,

Mona

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.

Answer 4

Thanks again .But what do you mean by correct permission?

It has right permissions because its executed successfully on retry. I mean we have a logic in sql agent job step ,If step failed first time there is a retry . and our packages always successfully executed on retry. 

Answer 5

Hi SR_MCTS,

Please try to set the Delay Validation as True in SSIS package.

The following link will be helpful:

  Delay validation properties in SSIS

Best Regards,

Mona

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.