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 |
|
greatlakes
Starting Member
3 Posts |
 Posted - 2005-02-24 : 14:16:14
|
Currently, we are using DTS to basically perform a 3 step process:1) Get data from Oracle and place it on a SQL Staging Database2) Migrate the data from the Staging Database to the Reports Database (both residing on SQL Server)3) Massage tables residing on the Reports Database to populate tables.We are successful in both steps 1 and 2, but when we try to migrate data from one table to the other, we receive the error message: 'cannot alter a varchar to numeric' when it has processed 41,000 records. Is this due to the fact that the DTS uses Excel to perform loads and Excel can only handle up to 65,000 records? We want to peform a transfer of over 100,000 records.Has anyone out there encountered this before??? |
|
|
Wyatt70
Starting Member
6 Posts |
Posted - 2005-03-02 : 13:02:24
|
| Excel will return a specific error message when the amount of data it is attempting to import is more than can fit into a single worksheet. So I don't think that is the issue here.The error message indicates that Excel was attempting an "implicit conversion" of a data value somewhere in the vicinity of row 41,000. I would start by examining these rows in this table in your staging database to see if SQL Server did an implicit conversion of any of your numeric values to a character datatype.Also, can you explain the process you used for #3? Some kind of code sample could help us troubleshoot your issue. |
 |
|
|
|
|
|
DTS Transfer with Excel