Generate a Staging Load Package from a View
Reads INFORMATION_SCHEMA for a configurable source view to optionally drop and recreate the destination table, then emits an SSIS package that truncates the staging table, optionally drops and rebuilds its indexes via stored procedures, and loads it from the view via an OLE DB source-to-destination dataflow with FastLoad.