Hi

I am unable to import html file into sqlserver 2000 database .
The problem is if the column is numeric(99999) in the first row ,dts
transformation is asuming the whole column as numeic and unable to import
alphanumeric rows. if i manually change the column to alphanumeric(A999999)
in the html file then i am able to import all alphanumeric data into the
table.

Any solution to import data with out manually changing the html file.





thanks

--
Message posted via http://www.sqlmonster.com