DTS if .. do somthing

How I can do If instruction in DTS ??

example

select @.data=date form table where id=32

if @.data='2007-10-22'

copy data to exel from table2 (I have this in 3 elements(OLE DB Source,Data Conversion,Flat File Destination)

else

do nothing

I don't now how to do if instraction.

Pleas help me.

FYI - Did you know that DTS has been deprecated, and that SSIS is the new approach?

|||I have register my dts in sql server ...|||

Don't use an if statement, build the conditional logic into the where clause of your select statement.

select * from select table where id=32 and date='2007-10-22'

Copy whatever is found in the next step in the process flow. If no data is found, nothing will be copied.