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 |
|
Royal
Starting Member
32 Posts |
 Posted - 2007-01-29 : 13:20:06
|
| Hi!I am new .. very grateful for some advice. How do I eliminate duplicate ref keys Or should I have cache mode PARTIAL?[Data Conversion [4910]] Error: Data conversion failed while converting column "salesperson_id" (88) to column "Copy of salesperson_id" (4929). The conversion returned status value 6 and status text "Conversion failed because the data value overflowed the specified type.". [Lookup [3882]] Warning: The Lookup transformation encountered duplicate reference key values when caching reference data. The Lookup transformation found duplicate key values when caching metadata in PreExecute. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-29 : 13:33:24
|
| Two errors. 1) The data does not fit the datatype.Either expand varchar column width or change from smallint to int.2) You are trying to insert duplicate data.Peter LarssonHelsingborg, Sweden |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-29 : 14:22:07
|
| You might need to add a data conversion task to convert to the output column types.The lookup error is fairly explanatory.==========================================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. |
|
|
|
Royal
Starting Member
32 Posts |
Posted - 2007-01-30 : 04:10:00
|
| 2) You are trying to insert duplicate data.How do I actually remove duplicates. I found a "nsort" function but it doesn't exist in my version. |
|
|
|
|
|
|
Duplicate keys and conversion