SQL Server Performance

Data Type Conversion Problem

Discussion in 'SQL Server DTS-Related Questions' started by danny123, Aug 2, 2006.

  1. danny123 New Member

    i am using dts service to import data from excel sheet to the db table.
    but it gives conversion prob like
    Source is using DBType_R8 and desination DBType_NUMERIC :conversion not possible
    please help.
  2. Adriaan New Member

    Excel is about the worst sort of data source - by definition, everything is free-text. Sometimes, if you're lucky, someone has been very careful. But they don't always have the same default formats that you might be expecting.

    So take a close look at what data you're receiving.

Share This Page