I have data coming from a text file that has dates
incorrect (ex: 04-2-1493) which should be 04-2-1943. The
table it is going into is a datetime field and spits out
an error when it comes to these record (seems to be over
1000 + records). How should I handle that in a DTS
process, should I just make the column it is going into a
varchar(10) or deal with it as it goes in. I definitely
want that record to go in since I am reliant on the other
information in that record and since there are over 1000
records with the same error (typos)?

Thanks

I think the best way is to deal with it in your DTS as it goes in.
Set up your transformation for this field as ActiveX Script - type
transformation and write a script that handles this case. You can use
standard VB functions like InStr, CDate to correct the date.

Regards,
Ilona Shulman


"Kenny Taylor" <anonymous (AT) discussions (DOT) microsoft.com> wrote

If you make it a text destination then it will load but still be wrong
right?

How about you do something like

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Kenny Taylor" <anonymous (AT) discussions (DOT) microsoft.com> wrote