Just need help on this as I am new at SSIS. I got an expression but i want yesterday. Not today
"Daily "+ (RIGHT("0" + (DT_STR,4,1252) DatePart("yyyy",getdate()),4))+(RIGHT("0" + (DT_STR,4,1252) DatePart("mm",getdate()),2))+(RIGHT("0" + (DT_STR,4,1252) DatePart("dd",getdate()),2))+".CSV"
Currently it looks like this
Daily 20161006.CSV
I want is
Daily 20161005.CSV
Aucun commentaire:
Enregistrer un commentaire