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 |
|
Asfakul
Starting Member
2 Posts |
 Posted - 2010-10-28 : 10:48:48
|
| i have a DTS which transfers data from a excel to DB table,Recently it has come to notice that all the excel columns are copied to DB except one column...Please help.What can be possible reason |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-10-28 : 12:42:48
|
| Is that excel column mapped in DTS with column in table ? |
 |
|
|
Asfakul
Starting Member
2 Posts |
Posted - 2010-10-29 : 10:21:10
|
| Thanks for you r concern but all the columns are properly mapped.the data in the excel is in the form 0.9999999999999999 .the data type in the sql column is decimal(5,2). But it's reflecting zero in the DB |
|
|
|
|
|
|
SQL data base is not listing correct values where