Saturday Night SQL Virtual Group is an open forum for discussions about Business Intelligence and Databases. This chapter sets the stage for every Microsoft SQL Server professional to share knowledge, to learn new techniques, to get answers on various topics related to data technologies, and to resolve real world issues.

Populating a Data Warehouse with SSIS and BimlSnap

Sun, Nov 11 2018 01:00 UTC

Populating a Data Warehouse with SSIS and BimlSnap

This session will demonstrate how to leverage Biml Patterns, along with SQL Server Metadata, to rapidly build SSIS packages. The focus of this session will be on populating a data warehouse, however the concepts presented could be applied to most any ETL/ETL scenarios. The components used during this session: 1. Biml 2. BimlExpress 3. BimlSnap. Participants will receive: 1. Open source bimlsnap_v2 database 2. A complete 'SQL Server Metadata Manager' solution 3. A fully functional SSIS Framework. Attend to see how Biml can revolutionize your SSIS development!


Jim Miller

Jim has worked in various facets of the IT business for over 30 years, with a primary focus on data warehousing, reporting and analytics, business intelligence, data modeling (relational, multi-dimensional), ETL frameworks, database architecture, SDLC, object oriented analysis & design, as well as database performance tuning. In previous engagements, Jim has fulfilled roles as Data Architect, DBA, IT Director, and Senior Consultant. He also has experience in account management, marketing/technical support, and software application training. Jim has also had some extraordinary opportunities to lead IT organizations, with multinational participants, on reconstruction projects based in Bosnia as part of the Dayton Peace Agreement, and more recently in Iraq with the US Department of State. Specialties: ELT/ETL Development - Powered by BimlSnap (www.bimlsnap.com), Complete Microsoft SQL Server BI Stack, snowflake cloud database.

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