Importing Dates

[Omnillas]

Without additional coding, what are convenient methods for importing flat files with dates that are of the form yyyymmdd?

I have customized import scripts to account for the different format but I was wondering if DTS had an "intelligent" operation for date data-type imports.

 

[mrdenny]

Nope not really. Any options will require some sort of coding.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[MDXer]

the one task that would probably be the least effort would be the time transform in the data transformaion task. It has 2 inputs source format and desired output.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck