I learned the hard way that, sometimes the accounting department will hide or strikethrough records when they really intend for them to be deleted. To a non-technical user, it seems logical that, if they strike-through an entire row or a cell within a column, then that means it's deleted.

Of course, these "deleted" records still exists when the Excel sheet is imported into a SQL Server table by a scheduled SSIS process. :exclamation:

Dammit, why did the ETL process import the record; can't the guys in IT plainly see that the rows were "deleted"? :angry:

Oh, well, I guess it's time to "fix" the ETL process. 😛