Our DTS PAKAGE can not run

• Thinky Night

  SSCommitted

  Points: 1663

  More actions

  September 24, 2012 at 7:58 am

  #262043

  Hi All,

  Suddenly my dts package on agent failed. And giving below error:

  Executed as user: MYDOMAIN\b2b.admin. ....3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:20:00 Error: 2012-09-24 10:20:02.95 Code: 0xC0047062 Source: Data Flow Task Script Component 1 [300] Description: System.Net.WebException: The server committed a protocol violation. Section=ResponseStatusLine 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(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket) End Error Error: 2012-09-24 10:20:02.95 Code: 0xC0047022 Source: Data Flow Task DTS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Script Component 1" ... The package execution fa... The step failed.

  Here are a web service.