Hi,

I have a text file in which one field is a date but in
file it is in '20030818' format and I am tring to import
that file to a table which has a column datetime.

is it possible to convert '20030818' to datetime during
DTS import?

if yes please let me know how ?

Thanks.

SQL Server should implcitly convert that format to datetime look at this
example

CREATE TABLE IsItADate (colA datetime)
INSERT IsItADate(colA) VALUES('20030818')

select * from IsItADate

colA
------------------------------------------------------
2003-08-18 00:00:00.000

(1 row(s) affected)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Ram" <mail_info (AT) rediffmail (DOT) com> wrote