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 an independent software developer and trainer based in Dallas, TX. He has worked with SQL Server since 6.5. He also develops .Net applications. He has worked with clients such as the Dallas Cowboys, T-Mobile ,Coca Cola Enterprises, and Bank of America. His specialty is developing ETL applications using SSIS, DTS and custom code. Currently he works as a Microsoft Certified Trainer, providing SQL Server instruction across the country.