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 |
|
jennypretty
Yak Posting Veteran
96 Posts |
 Posted - 2005-03-30 : 15:51:26
|
| HELLO friends,I exported the data from on Access table to an excel spreadsheet and used SQL Server DTS to transfer the excel spreadsheet to sql table and it show error. My table has about 2000 rows."Error during Transformation 'DirectCopyXform' for Row number 1. Errors encountered so far in this task: 1.TransformationCopy 'DirectCopyXform' conversion error: General conversion failure on column pair 10(sourse column 'Cost_to_org'(DBType_WSTR), destination column 'COST_TO_ORG'(DBTYPE_NUMERIC)).I keep changing the format from the excel sheet, but the same error shows up. I also tried to changed the dbtype for COST_TO_ORG column but it still doesn work.PLEASE HELP.jENNY.The stupid question is the question you don't ask.www.single123.com |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-03-30 : 16:15:53
|
| I would advise going to the original Access table for the DTS.This will KISS it.JimUsers <> Logic |
 |
|
|
jennypretty
Yak Posting Veteran
96 Posts |
Posted - 2005-03-30 : 16:34:06
|
| woh woh woh, it worked.thanks,Jenny.The stupid question is the question you don't ask.www.single123.com |
|
|
|
|
|
|
DTS Data Transformation Error PLEASE HELP