Josh, you learned something cool or figured something difficult out relating to BI/SQL/C#/Programming/Etc. Therefore write it down here for easy recall!!!
To continue from the last post, you'll need an SSIS package to drive the process. This package joins all the steps, running the custom code, the SQL Scripts, and Checking In the changes. Here's what you came up with...