How Documentation Leads Me to Smarter Programming

“Okay, so these are the steps to take in order to run this process.

Step one: rename the file. Wait. Why would I rename the file? SSIS can do that for me in a script task. No need to bother the operator with that.

All right. Step one: copy the file to a staging folder…hang on….a script task can do that too. Let me just throw a File.Copy in there.

Step one: Open the Excel file and delete the header rows (1-5) on the sheet labeled “Data”. ¬†Okay, step two. No, no, I can just tell the connection manager to ignore the first five rows. Let me go fix that up. There, much better.

Step one:…”