Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ikaddoura
Starting Member
3 Posts |
 Posted - 2006-01-23 : 13:37:46
|
| i had a problem in my DTS, one error say ( Syntax error converting the varchar value 'INDICE' to a column of data type int)so what does that supposed to mean and any idea how to fix that problemthank youP.S: i am a bigginer in SQL.kaddoura |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-01-23 : 13:48:51
|
| What the error is telling you is that there is a mapping between an attribute in the source (character) and an attribute in the destination (int). SQL will try an implicit conversion from source character data to destination int data. In your case though you have charcter data in the source field that cannot be converted to inti.e. YourName |
 |
|
|
ikaddoura
Starting Member
3 Posts |
Posted - 2006-01-23 : 16:18:47
|
| i checked all my indice and they are only 1000 record (it is a test record before touching the original one) and all of then are fine....so what else should i do??kaddoura |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-24 : 00:23:56
|
| The integer column is receiving the valie 'INDICE'Check it againMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Syntax error converting Var