Managing SSIS packages in large environments can be a real challenge. This session will show you how to deploy, transfer, monitor, standardize, and automate your SSIS package environment using Powershell. You’ll learn how to keep packages on data marts in perfect synch with each other, deploy packages to multiple servers, consolidate packages to a single server, enforce naming and security standards, and much more. The session starts with the basics and builds up to a final script that gives you a completely automated hands-off solution for deploying any package to any server in your organization. You will honestly be wondering how you ever got by without this.

Speaker Bio: I'm a SQL Server MVP and have been involved with SQL Server since 1995. I've also been working with multi-terabyte, high-transaction DBs since before they were popular. I'm a Contributing Editor and the sole database expert for InfoWorld Magazine which means I also touch DB2, Oracle, Sybase, and any other DB out there. I've also written for SQL Server Magazine, SQL Server Standard, SSWUG, and SQLServerCentral.com.

Session Goal #1: Learn to deploy, export, and transfer SSIS packages to and from one or many servers.

Session Goal #2: Learn to enforce naming standards, security standards, and versioning standards.

(Please note: cannont click through to speaker details from speaker's name below)