Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Our DTS PAKAGE can not run Expand / Collapse
Posted Monday, September 24, 2012 7:58 AM


Group: General Forum Members
Last Login: Thursday, June 25, 2015 7:21 AM
Points: 136, Visits: 307
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.
Post #1363496
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse