data type for decimal

• QQ-485619

  Ten Centuries

  Points: 1195

  More actions

  June 14, 2011 at 3:00 pm

  #148123

  In a sql 2005 ssis package, I want to pass a sum of a column (PaidAmt), which is a decimal (8,2) to a variable. what data type I should set for the vaiable?

  Thanks,

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  June 14, 2011 at 3:42 pm

  #1338697

  Please see the section "Mapping Integration Services Data Types to Database Data Types":

  http://msdn.microsoft.com/en-us/library/ms141036.aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato