Wednesday, Aug 21th, 2013
6:30 PM Meet & Greet | 7 PM Presentation
We would like to apologize for last June. We promised you a Mike lecture and ended up swapping at the last minute do to a little emergency room action. We are all better than ever and back on track.
Microsoft has provided some great tools for creating and editing SSIS packages. First Business Intelligence Development Studio (BIDS) then SQL Server Data Tools (SSDT). However, when creating an SSIS package you frequently repeat the same steps over and over. BIML is an XML markup language designed for representing the structure of an SSIS package. BIML Script takes that structure and generates an SSIS package.In this session we will use BIDS Helper to create a simple SSIS package using BIML. We will handle a couple SSIS scenarios with BIML and BIML Script.
Russ Loski is a SQL Server developer and occasional DBA with fifteen years of experience. He has designed databases and created the SQL code to support applications for the Dallas Cowboys, Bank of America, T-Mobile, Coca Cola Enterprises and others. In addition, Russ has developed large data loading projects using Microsoft's SQL Server Integration Services and its predecessor Data Transformation Services. He has developed reports using SQL Server Reporting Services. Russ is a regular contributor to the MSDN news groups as well as to the SQL Saturday events sponsored by SQL PASS. He occasionally blogs at http://www.sqlmovers.com and his twitter account is @sqlmovers.
Additional notes: Dominic Nagy over at the InSource Group has a couple of contract to hire gigs in both Las Colinas (Database Developer) and Addison (SQL DBA/Developer).
Also, Paul LaGrone is making his way back North! Look for his new users group to be starting in Waco!