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
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