I'm using Visual Studio Pro 2017 v15.9.11 to create a basic SSIS Package to read data from a CSV File.
In my SQL Table (I am importing INTO) I have a column - [InvAmt] as decimal(19,2)
In my Flat File Connection Manager, (for th eCSV Import file) the column is set :
DataPrecision = 0
DataScale = 2
DataType = decimal [DT_DECIMAL]
A value of 250.72 gets imported as 272.00 truncating the decimal value.
I tried changing the column setting to
DataPrecision = 19
DataScale = 2
DataType = numeric [DT_NUMERIC]
and I get the same result.
Any ideas?
Thanks in Advance.
Chuck
In my SQL Table (I am importing INTO) I have a column - [InvAmt] as decimal(19,2)
In my Flat File Connection Manager, (for th eCSV Import file) the column is set :
DataPrecision = 0
DataScale = 2
DataType = decimal [DT_DECIMAL]
A value of 250.72 gets imported as 272.00 truncating the decimal value.
I tried changing the column setting to
DataPrecision = 19
DataScale = 2
DataType = numeric [DT_NUMERIC]
and I get the same result.
Any ideas?
Thanks in Advance.
Chuck