Conversion chart of SSIS data types to SQL Server data types: Should I choose numeric or decimal?

user_13364866 0
Viewed 339

I'm a SSIS and SQL beginner, and I'm trying to understand what data type I should choose. The SQL Server data type is [decimal](4, 3), and there are two conversion options, decimal and numeric. Which one is more appropriate in this case?

ssis tsql sql-server sql types
1 Answers

Referring to the SSIS official documentation you should use DT_NUMERIC data types.

Note that there is a similar data type available in SSIS called DT_DECIMAL. DT_NUMERIC supports a wider range than DT_DECIMAL.

Based on the official documentation, DT_DECIMAL is defined as:

An exact numeric value with a fixed precision and a fixed scale. This data type is a 12-byte unsigned integer with a separate sign, a scale of 0 to 28, and a maximum precision of 29.

While DT_NUMERIC is defined as:

An exact numeric value with a fixed precision and scale. This data type is a 16-byte unsigned integer with a separate sign, a scale of 0 - 38, and a maximum precision of 38.

user_70312300
Related