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 |
|
carl_swensson
Starting Member
1 Post |
 Posted - 2007-09-03 : 04:35:54
|
I'm trying to import a text file which contains dates and decimal values. My problem is that the date has the following format "YYYY-MM-DD" and the decimal sign for the values are "." (dot). If I change the "Locale" for the file source so it will handle the "." signs in the values then the dates are invalid, and if I have it so the dates are handled then the "."s aren't seen as decimals.Is it posible to handle this problem in SSIS  Thanks |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-08 : 15:30:19
|
| do a convert in your import, the txt file will interpret the date as string, so i'm wondering how changing the locale will affect it.--------------------keeping it simple... |
 |
|
|
|
|
|
Decimal sign problems