Postgres Pro
Downloads
Home   >   mailing lists

Excel Source [24]] Error: System.Exception: SqlTruncateException: Numeric arithmetic causes - Mailing list pgsql-general

From Anthony Apollis
Subject Excel Source [24]] Error: System.Exception: SqlTruncateException: Numeric arithmetic causes
Date
Msg-id CAJyMCYK0jzjRt6P0rqhahvYen_yCMPJwwSSsf9v9YGa3ju3MnA@mail.gmail.com
Whole thread Raw
Responses Re: Excel Source [24]] Error: System.Exception: SqlTruncateException: Numeric arithmetic causes  (Anthony Apollis <anthony.apollis@gmail.com>)
Re: Excel Source [24]] Error: System.Exception: SqlTruncateException: Numeric arithmetic causes  (Erik Wienhold <ewie@ewie.name>)
List pgsql-general
Tree view
Please assist. I am using SSIS to read data from an Excel sheet into Postgres. I have increased the column size a few times, just cant seem to get the data in. Getting errors relating to destination column size.

[Excel Source [24]] Error: System.Exception: SqlTruncateException: Numeric arithmetic causes truncation.. RowNumber=1, ColumnName=Metric Value [DataType=DT_NUMERIC,Length=0], Data=[Length=12, Value=311116655.63]
   at ZappySys.PowerPack.Adapter.SqlDataComponentBase.HandleException(Exception ex)
   at ZappySys.PowerPack.Adapter.SqlDataComponentBase.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)
Attachment

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Orphan files filling root partition after crash
Next
From: veem v
Date:
Subject: Re: Question on Table creation