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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-19 : 08:45:49
|
| Jarp writes "I have a DTS to import some tables from a SyBase 11.5 database server to a SQL 2000 Server. The problem is that when the DTS package is run locally from the SQL server some records, in fact some numeric columns values, don't load properly, i.e. a value that must be 1369 it's loaded as 0.This has only happen with numeric values.Now the weird thing, when the package is executed from a different computer than the local SQL server the information is loaded perfectly! And even weirder is the fact that the values that are corrupted are always the same records.I've tried different ways to solve this problem but I don't seem to be getting any closer to the answer, I'd appreciate any help that you could provide me.Thanks in advance." |
|
|
|
|
|
DTS Data integrity problem