[SSIS] Get the the specific line in error in a OLE DB Destination RRS feed

  • Question

  • Hi,

    I'm using an OLE DB destination component to insert data in an SQLServer DB. I insert by 10000 line.
    I have a line witch is bad formatted so I get the error:
    The value is too large to fit in the column data area of the buffer.   at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)   at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)";;

    Is there a way to get the line which generated this error (the bad formatted data I mean)?

    Thank you,
    lundi 11 janvier 2010 10:29


Toutes les réponses