I have a dts package that imports data from a comma delimited .csv file.
I'm getting a conversion invalid for datatypes on column pair 1 (source 'col0012' (DBTYPE_STR), destination column 'latitude' (DBTYPE_R8)).
So, the source file is populated as a string for 'col002' and I have that field specified as a float within my table. Float is the correct type for the value.
How can I make the conversion correctly during the dts execution.
Thank you.do you have any empty strings in the source file going to the float column?|||Also - does your CSV include column headings and, if so, have you ticked the box in the DTS to let SQL Server know that?sql
Showing posts with label datatypes. Show all posts
Showing posts with label datatypes. Show all posts
Wednesday, March 21, 2012
Subscribe to:
Posts (Atom)