THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Sergio Govoni

A place where share my experience on SQL Server and related technologies

Automate Your ETL Infrastructure with SSIS and PowerShell

SQLPASS TV channel has been published the session Automate Your ETL Infrastructure with SSIS and PowerShell that Allen White (@SQLRunr) has done during the PASS Summit 2013. 

Abstract

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.

Link

http://www.youtube.com/watch?v=rlrw0dNmFdU&list=PLoGAcXKPcRvbTr23ujEN953pLP_nDyZJC 

Enjoy the session and thanks to Allen White!

Published Wednesday, December 25, 2013 11:57 PM by Sergio Govoni
Filed under: , , , ,

Comments

No Comments
Anonymous comments are disabled
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement