I have a DTS that is reading a txt file. Part of the txt
file is being imported into 1 table using a datapump
task. That part is fine

The second part of the file i read into global varibles
and use a EXECUTESQL Task to inset them to another table.
I wont go into the reasons for this. This part of the
file contains dates ( i.e 01/01/2004' as strings. I need
to import them to the table as smalldate values. What
is thew best way to do this.. 1, should i set the Global
Varable as a date ? or should i use a cast function in
the execute SQL task ?

I find this way works for me

Formatting Character Data into Datetime fields
(http://www.sqldts.com/default.aspx?249)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Peter Newman" <anonymous (AT) discussions (DOT) microsoft.com> wrote