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.