Dominic is the Data Architect with The Reinvestment Fund in Center City Philadelphia. He has studied OO programming since 1995 and database software since 1999 (SQL Server since 2001). He currently works with SQL Server 2014 and .NET C#, doing data analysis and manipulation, as well as writing code management software. In his spare time, he takes studies Chinese Acrobatics and Juggling at the Philadelphia School of Circus Arts in Germantown.
T-SQL is a very complicated language to parse, so it can be intimidating to get started. We’ll go over basic concepts of what a lexer/parser is and what to expect from it. Then, using the TransactSql.ScriptDom library in the SQL Server SDK, we’ll do some examples to get our feet wet.
Using the .NET API, we’ll design and run existing packages, and create a new one. We’ll discuss the different objects a package contains, see how to query a package’s contents, and how to edit field-level component transformations.