Sample Header Ad - 728x90

How to format SSIS Expression for weekend

-1 votes
1 answer
1444 views
I have the following format to account for weekends while naming an excel output. How do I get only the date and not the full startime formatted like 20150429? ((DT_I4)DATEPART("weekday",@[System::StartTime]) ==2 ? Replace((DT_STR, 20, 1252)(DATEADD( "D", -3,@[System::StartTime])),":","") + ".xlsx" : Replace((DT_STR, 20, 1252)(DATEADD( "D", -1,@[System::StartTime])),":","") + ".xlsx")
Asked by gaktheknife (123 rep)
Apr 29, 2015, 01:04 PM
Last activity: Apr 29, 2015, 04:21 PM