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 |
|
qdaddyo
Starting Member
7 Posts |
 Posted - 2008-02-11 : 15:38:43
|
| I'm extracting columns from a CSV file.Once column, in the CSV file, has a format of general and is only populated by numbers (0 - 126); no decimal places.During the extract, the column is copied into my staging table as an NVARCHAR value. However, after the extract, the values have all been appended with a ".0". What could be causing this?Thanks! |
|
|
georgev
Posting Yak Master
122 Posts |
Posted - 2008-02-17 : 11:23:56
|
What happens if you change the data type of field in the staging table to one more apropriate (eg. integer)?
George<3Engaged! |
 |
|
|
qdaddyo
Starting Member
7 Posts |
Posted - 2008-02-19 : 11:52:10
|
| Thanks! I actually had the person in charge of the export change the field from number to text. This worked! |
|
|
|
|
|
|
Extract Issue (".0" added to values)