The PowerShell Virtual Chapter is geared towards those wanting to learn more about PowerShell and to share best practices.
Next Meeting

Wed, Sep 18 2013 12:00 Eastern Daylight Time

SSIS - Integrating PowerShell in a ScriptTask comp


SSIS - Integrating PowerShell in a ScriptTask component

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.



Previous Webcasts

Below are a few of our previous sessions.


PowerShell MVP Mike F. Robbins will cover PowerShell basics, and why PowerShell matters to SQL Server database administrators.

Stupid PowerShell Tricks

PowerShell MVP Jim Christopher demonstrates a few of his favorite PowerShell tricks.

Simplifying SQL Server Migrations using PowerShell

PowerShell MVP Chrissy LeMaire demonstrates how to migrate SQL Server databases, logins, jobs, operators, and other SQL Server components with just a single command.

Maintain SQL Server Performance Baseline with PowerShell

SQL Server MVP Allen White walks you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

Making PowerShell Useful for your Team

SQL Server DBA with a beard, Robert Sewell demonstrates how to turn your one-off scripts into shareable functions and how to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions.

Carpe Scriptum! Make the PowerShell ISE Work for You

PowerShell MVP Jeffery Hicks shows you how to get the most out of the PowerShell ISE. From snippets, to customizing the look and feel, to creating your own add-ons you'll be eager to open up the ISE and get started.

PowerShell Tips and Tricks for SQL Server Administration

Data Artisan Mike Fal covers a handful of useful scripts and patterns in PowerShell that will ease your management of SQL Server.

. - Thursday, April 9, 2015

View Recordings of Previous Sessions on Our YouTube Channel

 read more ...