Dynamic date in Connection string in the SSIS package

RIGHT((DT_STR,4,1252)YEAR(DATEADD("dd",0,getdate())),4) 
+""+ RIGHT("0"  +(DT_STR,4,1252)MONTH(DATEADD("dd",-1,getdate())),2)
+""+ RIGHT("0" +(DT_STR,4,1252)DAY(DATEADD("dd",0,getdate())) ,2)