msbi - Yesterday's date in SSIS package setting in variable through expression -

msbi - Yesterday's date in SSIS package setting in variable through expression -

i setting variable in ssis bundle , giving look "datepart("yyyy", getdate())*10000 +datepart("month", getdate())*100 +datepart("day",getdate())" give me variable value 'yyyymmdd'. problem want yesterday's date.

for illustration on 11/1/2014 should 20141031

you can utilize dateadd function look :

datepart("yyyy", dateadd( "day",-1, getdate()))*10000 + datepart("month", dateadd( "day",-1, getdate())) * 100 + datepart("day", dateadd( "day",-1, getdate()))

ssis msbi