Cannot create ActiveX component.

  • Thread starter Thread starter Billpete002
  • Start date Start date
B

Billpete002

Guest
Hi All, I have inherited numerous VS packages and one of them has given me nothing but grief since taking it on. I have worked through numerous bugs on it to where I can run the package manually in VS but when running the package on Microsoft SQL Server (SSIS) I get:

Microsoft (R) SQL Server Execute Package Utility Version 14.0.3023.8 for 64-bit Copyright (C) 2017 Microsoft. All rights reserved. Started: 10:49:25 AM Error: 2020-02-19 10:49:26.76 Code: 0xC0047062 Source: Script Component Description: System.Exception: Cannot create ActiveX component. at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute() at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper) End Error Error: 2020-02-19 10:49:26.76 Code: 0xC004701A Description: Script Component failed the pre-execute phase and returned error code 0x80131500. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:49:25 AM Finished: 10:49:26 AM Elapsed: 0.953 seconds. The package execution failed. The step failed.,00:00:01,0,0,,,,0


SQL Server 2017 is 64bit, SQL SSIS 2017 is 64bit, and Visual Studio 2017 is 64bit.

I have looked up the error codes and "Cannot create ActiveX component" and still nothing that makes sense. The process is connecting to a website and uploading the data. It runs perfectly fine when ran in Visual Studio - but spits this out in SQL...

Continue reading...
 
Back
Top