Sul canale SQLPASS TV è stata pubblicata la sessione Automate Your ETL Infrastructure with SSIS and PowerShell tenuta da Allen White (@SQLRunr) durante lo scorso PASS Summit 2013.
Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious, and it’s easy to miss something in the process of generating the same basic package over and over again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session, we’ll see how you can use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.