Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SSIS - Max Concurrent Executables Diagnostic

88 views
Skip to first unread message

Ron Ruble

unread,
Jul 25, 2008, 2:43:01 PM7/25/08
to
We have had intermittent failures in SSIS packages running at night where
there is no indication of a problem until a low-level error occurs.
Re-Running the package works fine.

One thing I noticed is that there are a number of messages in the
dbo.sysdtslog90 table saying: "Based on the system configuration, the maximum
concurrent executables are set to 18."

However, I have been unable to find any information about this diagnostic. I
don't know if it is purely for performance tuning, or if this is a warning of
another problem that needs to be addressed. Shortly after this messge, we see
another: "System.Data.OleDb.OleDbException: The statement has been
terminated. String or binary data would be truncated. 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)"

But again, re-running the package is fine, it does not appear to be data too
long for a field. Searching google provides only guesswork. What does this
diagnostic indicate, and could it be related to the problem or just a
coincidence.

0 new messages