Saskatoon SQL Server User Group

Next Meeting

Friday,

May

26

Meeting 5 of 2017

Meeting number 5 is scheduled for May 26th, 2017.  The topic will be on powershell.

For those that attended April's meeting, we got a tutorial on the basics of Powershell (I know it felt a bit overwhelming at times especially since some of us hadn't really used powershell much before), but I want to continue with the powershell theme for a few meetings.  So for May's meeting, the topic will be "Analyzing your ETL Solution with PowerShell" presented by Andre Kamman.  The abstract:

Some ETL solutions have built-in mapping so that you can easily find the parts that need to change when you want to change something in the sources or destinations. Unfortunately, SQL Server Integration Services (SSIS) does not have this functionality, so finding which package uses which columns in your databases and source files is not always easy. Fortunately, PowerShell can do this task for you. This session shows you how to analyze a few hundred SSIS packages and even make changes, if needed. After this session, you will know how to more easily estimate how much work proposed changes to your sources or destinations require in your ETL solution.

Hope to see you there!

PASSChapterLogo.jpg

Upcoming PASS Sponsored Events:

  • ONLINE EVENTS:

  • IN PERSON EVENTS:

  • 24 hours of PASS - here

    PASS BA Days - here
    BA Marathon - herePASS affiliated conferences - here

    And can't forget SQLSaturday (aka mini-Summit) - here

    Back to Top
    cage-aids
    cage-aids
    cage-aids
    cage-aids