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...
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...