Data in Excel On Wed, 28 Feb 2024 at 22:22, Anthony Apollis <anthony.apol...@gmail.com> wrote:
> 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) > >