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)
Showing posts with label Dynamic date in Connection string in the SSIS package. Show all posts
Showing posts with label Dynamic date in Connection string in the SSIS package. Show all posts
Wednesday, April 11, 2012
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)
Subscribe to:
Posts (Atom)