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 |
|
JJ297
Aged Yak Warrior
940 Posts |
 Posted - 2008-09-19 : 11:38:11
|
| Hello I have a flat file and I'm trying to use the Fast Parse to convert the date field from 20080812 to 08-12-2008. I loaded my Flat File ConnectionInput and Output Properties and changd FastParse = True and DataType (DT_DBTIMESTAMP)It runs but my date is coming out as 2008-08- What am I missing? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-26 : 04:17:49
|
Source is 8 characters only, thus will target be 8 characters only.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
JJ297
Aged Yak Warrior
940 Posts |
Posted - 2008-09-26 : 09:16:45
|
| Thanks again! |
|
|
|
|
|
|
Fast Parse