I'm using the DTS to import a csv file into a table sql server. The test works fine but when I go to execute I get an error saying theirs a conversion problem with one of the fields in the csv file and the db field. The first one was a column called price which in the csv file takes the format $3.99 etc, the corresponding field type in the db is 'Money'.
So to make it happy I just removed the association between them and tried it again. This time I got another conversion error on a Field called 'Weight' ie 1.3, the corresponding field in the db is of type Decimal.?@.#$$#%
Why won't DTS accept these conversions they look correct to me.
Please help.I think you should use the Microsoft Text Driver instead of OLEDB to import CVS, and sometimes SQL Server have problem taking money from CVS or other sources try Numeric for money and integer for Decimals. Hope this helps.
Kind regards,
Gift Peddie
No comments:
Post a Comment