Home Forums SQL Server 2005 Business Intelligence SSIS Importing issue with EXCEL RE: SSIS Importing issue with EXCEL
Ganesh Lohani
Hall of Fame
Points: 3091
More actions
March 4, 2010 at 7:41 am
#1128507
Use data type Numeric(7,2) or
or
you can use CAST function.
For example,
select CAST(24.4567 AS DECIMAL(4,2)) AS Price