Variable Expression
hi
i want to get previous date value then send that to variable how to get previous date in SSIS by using Expression
May 23rd, 2012 3:41am
the prevous date from what? Column in your database, Source, today?
ex. from table with ExecuteSQL Task:
select max(date) from table where date < actdate
direct the output to a variable
ex. for today in Derived Column:
new colum, expression: dateadd("dd", -1, getdate())
Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2012 3:55am