SSIS Variables and Expressions Webinar
Bradley Schacht is a Principal Program Manager on the Microsoft Fabric product team based in Saint Augustine, FL. Bradley is a former consultant, trainer, and has coauthored 6 SQL Server and Power BI books, most recently Learn Microsoft Fabric. As a member of the Microsoft Fabric product team, Bradley works directly with customers to solve some of their most complex data problems and helps shape the future of Microsoft Fabric. Bradley gives back to the community through speaking at events such as the SQLBits, Fabric Community Conference, PASS Community Data Summit, SQL Saturdays, Code Camps, and user groups across the country including locally at the Jacksonville SQL Server User Group (JSSUG). He is a contributor on SQLServerCentral.com and blogs on his personal site, BradleySchacht.com.
Looks like it is that time again... for me to present a FREE webinar for good ol' Pragmatic Works today at 11AM eastern standard time. The topic today will be SSIS variables and expressions. I [previously did a webinar](https://bradleyschacht.com/ssis-webinar-recording-is-up "SSIS Configurations, Variables and Expressions") on a similar topic that also included configurations. If you were in that webinar then you are well aware that we really only got to go into detail on configurations and not the other two topics. So today is completely dedicated to variables and expressions. Feel free to bring your questions as I will be leaving some time at the end of the session today to answer those! Below are the details along with the registration link. Don't forget it is free! Who: Me When: September 20, 2011 at 11AM Eastern Where: Online: [Register Here](https://pragmaticworks.com/ "Webinar Registration") (Live via Go To Webinar) What: Building a dynamic SSIS package can be a daunting task. There are countless locations where expressions and variables can be used throughout SSIS. In this session Brad will walk you through the basics of variables including how SSIS deals with variable scoping. We will then take a look the unique expression language used in SSIS and how that can help in situations such as dynamic file names, connection strings and data cleansing. Next we will bring it all together and show how powerful SSIS can truly be by combing the functionality of variables and expressions. Topics will include user variables, system variables, the expression language, as well as where to use expressions and variables in the control flow, data flow and even event handlers to build a useful custom auditing solution.