How to convert DT_DBTIMESTAMP to Int

I have an int column in table and need to convert DT_DBTIMESTAMP column to int in Conditional_Split transformation editor.

SPOL_ProcessDate>CAST(CONVERT(varchar,DATEADD(day, 5,GETDATE()),112)ASint);

Does any know how to convert this is Conditional_Split transformation?

Thanks in advance.

[1100 byte] By [BaderCheema] at [2007-12-20]

# 1

How about:

SPOL_ProcessDate > (YEAR(GETDATE()) * 10000) + (MONTH(GETDATE()) * 100) + (DAY(GETDATE()))

-Jamie

JamieThomson at 2007-9-9 >

# 2

I knew you would come with as answer.

Thanks very much.

BaderCheema at 2007-9-9 >

SQL Server Hot Topic