Invalid data on DTS Import

• Jorge Olimpia

  SSC Enthusiast

  Points: 133

  More actions

  December 15, 2004 at 5:32 am

  #162865

  Hi friends,

  I have following problem:

  I´m importing data of a ODBC(Acucobol) to a SQL table, but in a column, where the source is decimal (or float), the destination goes to int. Example:

  source = 1,30 -> destination = 1.

  I make a test with Excel Data Import and the result was ok!

  Do you have a tip for this?

  Thanks,

   

  Jorge Olimpia - São Paulo / Brazil

• Charles Otten

  Default port

  Points: 1475

  More actions

  December 16, 2004 at 10:14 am

  #534185

  Are you sure the field in your table is not defined as an integer?  DTS is usually pretty good at importing correctly. 

  If the phone doesn't ring...It's me.