Hi Expert,
I have a simple problem to solve.
I have an Excel sheet with a Flag Column, My SSIS package picks up data from the Excel sheet easily.
At the end of the process I need to change the flag Updated? from Y to N.
This way when the users change the data in Excel they will know next month if they have not yet updated the data in the row.
How Do I get SSIS to write N instead of Y in the column.
Say the table has:
USER DATA UPDATED?
A 100 Y
After the package is run SSIS will update the Excel file and result in:
USER DATA UPDATED?
A 100 N
Next time the user looks at the table the following month, they will change it to Y. This is to check which user has updated data and who has not.
