Code level changes while migration from SQL Server 2000 to SQL Server 2005

• archan.arch

  SSC Enthusiast

  Points: 184

  More actions

  August 31, 2009 at 5:57 am

  #1046808

  Hi all,

  Need help in upgradation from SQL Server 2000 to 2005.

  I have migrated the DTS packages to SSIS.

  My package loads from flat files (data files) to my database.

  I am using BULK-INSERT statement.

  I am using non-html format files for blk insert

  My inp data contains spl characters

  Looks something like this

  12,180.01

  1,290.0

  My destination table has been defined as "float"

  I am facing the folowing error:Bulk load data conversion error (type mismatch or invalid character for the specified codepage)

  Cannot change the datatype to varachar.

  There is no problem while loading in 2000 with the same data and destination as float. But facing the error in 2005

  Please help..

  Thank you

  archana