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 |
|
sgraves
Starting Member
29 Posts |
 Posted - 2006-12-04 : 19:46:55
|
| I am trying to import data from excel into my server, but get this error message:Error during transformation 'directcopyXform' for row number 1. Errors encountered so far in this task 1. TransformCopy 'DirectCopyXform' conversion error: Conversion invalid datatypes on coulumn pair 19 (source column '*9' (DBTYPE_WSTR( destination column 'F19' (DBTYPE_R8)Anyone get me in the right direction?Scott |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-12-04 : 19:48:41
|
| How are you doing the import?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sgraves
Starting Member
29 Posts |
Posted - 2006-12-04 : 21:35:49
|
| I am importing via Enterprise Manager. I am right clicking on the table in which I want to import my data to and choosing the file and importing.Scott |
|
|
|
sgraves
Starting Member
29 Posts |
Posted - 2006-12-05 : 10:56:59
|
| Does anyone know if symbols such as commas, semi-colons, dashes will generate an error message when importing?Thanks!Scott |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-05 : 11:00:02
|
| DBTYPE_R8 is a numeric data type with fractions.The most obvious reason for this to happen is that a non-numeric character exists in one of the source records in column 19.Peter LarssonHelsingborg, Sweden |
|
|
|
sgraves
Starting Member
29 Posts |
Posted - 2006-12-05 : 11:35:20
|
| I have used an "*" when there is no data in the column. Don't I have to use something to fill the space when importing? I have a few columns with nothing in them, but I would need to use "*" to hold it's place, correct? Here is an example of what I am trying to import:189558 000-00-0000 * JOHN DOE * * 27881 MY STREET SUITE G157 MY HOMETOWN NY 85766 00/00/0000 * * * * * *I have a list of about 300 people with this information I am importing.Any ideas? Thanks for your help. |
|
|
|
sgraves
Starting Member
29 Posts |
Posted - 2006-12-05 : 11:36:41
|
| Sorry, each "*" represents an empty column or space where there is no data. The tables I am importing into have these columns available, but I just don't have the data right now.THanks!Scott |
|
|
|
|
|
|
importing data