在执行SSIS包时获取错误

In one of my project, I have to do some data transfer..So i created SSIS package for same but when i put it as schedule it throws me below error.

在我的一个项目中，我必须做一些数据传输。所以我创建了SSIS包，但是当我把它作为计划时，它会把我扔到错误下面。

    An exception of type System.Runtime.InteropServices.COMException occurred and was caught. 
Source:Microsoft.SqlServer.DTSPipelineWrap;Message:Exception from HRESULT: 
0xC0047020;Target:Int32 AddRow(IntPtr);StackTrace:   at 
Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSBuffer100.AddRow(IntPtr ppRowStart)     at 
Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.AddRow()     at 
Microsoft.SqlServer.Dts.Pipeline.ScriptBuffer.AddRow()     at 
OutAssetDetailBuffer.AddRow()     at ScriptMain.CreateNewOutputRows()  Method - 
CreateNewOutputRows()

Since i am new in SSIS package, i dont have any idea about this error. IF anybody knows what is the route cause behind this error than please let me know.

由于我是SSIS包的新手，所以我对这个错误一无所知。如果有人知道这个错误的原因，请告诉我。

Also, I have one doubt - Does SSIS package requires Interop?

另外，我有一个疑问——SSIS包需要Interop吗?

Thanks in Advance.

提前谢谢。

1 个解决方案

#1

I've had that error, and it was actually not due to an error in the script component, but an error with a downstream task that caused the issue. Once that was resolved, the issue disappeared.

我有过这个错误，实际上不是由于脚本组件的错误，而是由于下游任务的错误导致了这个问题。一旦解决了这个问题，这个问题就消失了。

Hope this helps.

希望这个有帮助。

#1