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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment