Invalid date

[Learnerprog]

Hello all,
is there a way to skip the bad date record in DTS
for example I have record with date '02/32/2006' and don't want to load it. Thanks alot

 

[smnetto]

--Supose that @dt is your field in dts:

declare @dt varchar(10)
set @dt='02/32/2006'

--So use a query in DTS like this:

select case when isdate(@dt)=1 then @dt else null end


Hope this help you.
Sergio - DBA SQL