I need to know if there is a way in SSIS to dynamically update a column in a table based on the DAY OF THE WEEK?
I have a source file that is proceed each day, but it contains one field that is ONLY updated on SUNDAY. So SUNDAY's data file will contain the most recent update.
I need to update my DESTINATION table on MONDAY AM with the data from SUNDAY's PM file.
Then I need to have my package IGNORE the column update for the rest of the week and then update it again only on MONDAY AM..
How can I accomplish this..?