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)