Groups | Blog | Home
all groups > sql server dts > june 2007 >

sql server dts : Import data using DTS cause data conversion error



Han
6/29/2007 7:04:01 AM
Hi all,

I am trying to import an csv file into SQL table, but I am having error with
float (integer), and date fields. String fields are ok. Isn't that SQL
takes care of these conversion automatically? If I have to convert data
manually, how can I do this, and what syntax?

Anyone having the same situation like this? Thanks a lot in advance.

Allan Mitchell
7/2/2007 12:00:00 AM
Hello Han,

Some things can be converted behind the scenes but others not. here is an
example of taking data and reformatting it from char to DateTime

http://www.sqldts.com/249.aspx

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

AddThis Social Bookmark Button