-
Notifications
You must be signed in to change notification settings - Fork 49
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Error HRESULT E_FAIL has been returned from a call to a COM component when running inside a SQL Server Integration Services pipeline #79
Comments
Interesting... The call stack stops short of showing any call into MagicScaler, so it's not clear what COM component the error is referring to. It's possible there's some CAS restrictions in place in SSIS that prevent unverifiable code, which would preclude running MagicScaler if so. |
If I run the package removing this line of code |
Right, I have no reason to doubt the call to Your next troubleshooting step will need to be to get better error information from the SSIS host to determine where the failure is occurring. |
We are using SQL Server 2012 and Windows Server 2008 R2 and I am not sure how to get better error information from SSIS |
Hi,
I am getting the below error while trying to execute the below code in script component in SSIS Package on server while it runs good on visual studio if execute manually.
Error:
Resize the Image:Error: System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket)
Code in Script component: In the below i am trying to resize the image whose length is greater than 400k to less than 400k
#region Namespaces
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
using Microsoft.SqlServer.Dts.Runtime.Wrapper;
using PhotoSauce.MagicScaler;
using System.IO;
using System.Text;
#endregion
///
/// This is the class to which to add your code. Do not change the name, attributes, or parent
/// of this class.
///
[Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute]
public class ScriptMain : UserComponent
{
#region Help: Using Integration Services variables and parameters
/* To use a variable in this script, first ensure that the variable has been added to
* either the list contained in the ReadOnlyVariables property or the list contained in
* the ReadWriteVariables property of this script component, according to whether or not your
* code needs to write into the variable. To do so, save this script, close this instance of
* Visual Studio, and update the ReadOnlyVariables and ReadWriteVariables properties in the
* Script Transformation Editor window.
* To use a parameter in this script, follow the same steps. Parameters are always read-only.
*
* Example of reading from a variable or parameter:
* DateTime startTime = Variables.MyStartTime;
*
* Example of writing to a variable:
* Variables.myStringVariable = "new value";
*/
#endregion
}
The text was updated successfully, but these errors were encountered: