Convert Data type

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  November 27, 2013 at 9:13 am

  #279554

  My source file in Excel has a datatype : Double precision float.

  What datatype should I use for SQL destination to make sure they both are in sync.

• Igor Micev

  SSC-Dedicated

  Points: 33109

  More actions

  December 9, 2013 at 3:19 am

  #1671848

  In SSIS appropriate is DT_R8 for Float,Double.

  In the destionation table you'd have Float as data type.

  Take a look here http://technet.microsoft.com/en-us/library/ms141036.aspx

  Regards,

  IgorMi

  Igor Micev,My blog: www.igormicev.com