“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.