4 docs tagged with "deployment"

Generate an SSIS package that drops every table in a target database by looping over INFORMATION_SCHEMA until no tables remain.

These are the code samples from the PASS BI Virtual Chapter meeting from 2013/12/12. For the video, check out "Create and Load a Staging Environment...

Use the BimlStudio command-line compiler to expand Biml files into SSIS packages outside the IDE so the build runs unattended on a schedule or in CI.

Drive multi-region SSIS deployment from a small set of metadata tables so the same source loads the same tables into per-region target databases.