ETL shootout-SSIS vs Powershell
I know what you're thinking, Powershell is not an ETL tool. And you're probably right. But I keep running into weird requests that were just easier to fix with Powershell. I'll show you why some things are not easy in SSIS. I'll also discuss how you can work around a lot of that instead of switching to Powershell like I did. This session will be around 70% "why is this hard in SSIS and can you work around it?" and 30% "Look how cool Powershell is"
André is a DBA and SQL Server Solutions architecht for CloudDBA.nl. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML), and even implementing PDW.
André is a Data Platform MPV, Dutch PASS Chapter Leader and organiser of SQL Saturday Holland