This session will demostrate how you can reuse a PowerShell script in SSIS "Script Task" component as part on a ETL flow. I'll be showing some basic .NET Script code in both C# and VB. I'll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell.
Session Level: Intermediate
Born in Puerto Rico, has been working with computers since 1979, and is the only PowerShell MVP in Florida. Throughout many years, have worked with various types of databases such as: Dbase, OS/400-DB2, MySQL and MSSQL. And, as a Senior IT/Developer has provided support for Windows Servers 2003/2008, Windows 7, SQL Servers Applications, Microsoft Virtualization Technologies, and building Visual Studio solutions. Microsoft PowerShell MVP awarded since 2008. Also, in 2010 got his SAPIEN Technologies MVP Award.