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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics