Dynamics Community Forum Thread Details

Hi all, I can not identify what is causing this error. Its an intermitent fault with an SSIS import package. For refernce we are running CRM 2011 on premise with SQL Server 2008 R2 over a live, application and web stack. I'm getting the following error via the Server Management Studio > Log File Viewer:

Executed as user: UOC\crm_support. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 17:30:01 Error: 2014-05-28 17:47:13.24 Code: 0xC0047062 Source: Get Data Core System then Ensure Student Records Exist in CRM then Create Application Records Under Associated Students Script Component [139] Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. 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) End Error Error: 2014-05-28 17:47:13.26 Code: 0xC0047022 Source: Get Data From Core System then Ensure Student Records Exist in CRM then Create Application Records Under Associated Students SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Script Component" (139) failed with error code 0x80131501 while processing input "Input 0" (141). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. End Error Error: 2014-05-28 17:47:13.27 Code: 0xC02020C4 Source: Get Data From Core System then Ensure Student Records Exist in CRM then Create Application Records Under Associated Students Core System Live DB [340] Description: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. End Error Error: 2014-05-28 17:47:13.27 Code: 0xC0047038 Source: Get Data From Core System then Ensure Student Records Exist in CRM then Create Application Records Under Associated Students SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Core System Live DB" (340) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 17:30:01 Finished: 17:47:13 Elapsed: 1031.49 seconds. The package executed successfully. The step succeeded.

As you can see it part completes then drops out. I have done as much trawling of the event logs and online forums as is humanly possible and now at brick wall stage.

Any help massively appreciated.