Handling Metadata from SQL Stored procedures in Visual Studio and SSIS

Sometimes when working within VisualStudio, you don't want it to be clever and parse your sprocs - you want it to be dumb and execute them.