sorry, Let me provide the SSIS ... I took your code and below article and come up with this, for Last Friday exact 5 pm:

DATEADD("HH",17,(DT_DBTIMESTAMP)((DT_STR,30,1252)(DT_DBDATE)(DATEADD("dd", -1 -...

• This reply was modified 5 years, 5 months ago by  v_sreedhar.
• This reply was modified 5 years, 5 months ago by  v_sreedhar.

-- SV: For understanding getdate() and things you need
select SYSDATETIME() as sysdatetime_FYI
, getdate() as getdate_FYI
, cast(getdate() as time) as getdate_TimeOnly
, CONVERT(varchar(15), cast(getdate() as time),100) as getdate_TimeOnly_AMPM
, DATEPART(HOUR,...

Thank you, it helped me.