This was a question asked to me in order to return the last day of the current week.
The main idea is to schedule a package update for Friday being the day of less Data Warehouse use.
The response is in this link, on an MSN forum, since I only changed another response:
The presented solution works in either T-SQL and SSIS (data converter tool) there can be other variations and there can be some that only work in one case like:
and a more complex way, by counting the week until now and then returning the last day of current week:
T-SQL & SSIS:
Any questions, explanations, just comment.