Marcus Aurelius
asked on
SSIS - How to dynamically update a column table based on DAY OF WEEK?
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..?
thanks
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..?
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
With that said... is there not a Task I can use in SSIS that will do this? Possible DERIVED COLUMN...or some other task..?
I'm hoping that SSIS can handle the day logic...for the field itself.....?