October 13, 2005 at 8:38 pm
when i was trying to load the table in to a database using DTS i got this error.
error converting data type varchar to numeric
can anyone please help me with this . it is urgent thanks!
October 13, 2005 at 8:54 pm
The error means exactly what it says.
Your inserting data into a column in a table that the data type is a numeric, but the data your inserting is in a string format (Char/varchar) In dts you need to performa transformation to cast it into the numeric dta type your using.
October 13, 2005 at 8:56 pm
how can i do that ?
can u please explain please
thanks!
October 13, 2005 at 9:02 pm
by the way i forgot to say something!
this database ahs 2 tables one summary and another report summary
iam loading the data from a .dat file into summary --which is running fine and then iam running a task to load the data in summary database into report summary database where iam getting an error --- error converting data type varchar to numeric
thanks!
October 14, 2005 at 7:29 am
A sample of your data would help, but I'm guessing that your original column has letters or other non-numeric values in it.
-SQLBill
October 14, 2005 at 9:21 am
I suggest you pick up a book, or read books online about dts.
Also http://www.sqldts.com/ is a great place to pick up information about dts.
Does your destination table have a column, or many columns with a datatype of numeric? By the error I am assuming yes.
If this is the case then in your data transfer task you need to look into the transformations and convert it into the proper data type. I cannot explain becuse I don't have enough information about your specific problem to solve it for U.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply