May 8, 2018 | Microsoft, SQL Server, SSIS, Tech Tips, Technical Information
By: Matt Wollner Adding custom logging and auditing to your ETL process can be very beneficial – so much so that if your organization hasn’t added it to your ETL process yet, we highly recommend doing so. Many developers rely on SSIS to log their SSIS...
Mar 7, 2018 | Microsoft, Microsoft Power BI, SQL Server, Tech Tips, Technical Information
By: Paul Schuliger During a recent reporting project, I came across a situation in which the solution was to provide the reporting tool (Power BI sourcing from an SSAS tabular model) a sort order for each level of a dimensional hierarchy. Without...
Feb 26, 2018 | Microsoft, SQL Server, SSIS, Tech Tips, Technical Information
By: Jharred Williams To kick things off, let’s start with a quick refresh on SQL Server Integration Services (SSIS) and what’s new with the tool today. To say SSIS is strictly a data extract, transformation and loading (ETL)...
Nov 16, 2017 | Conferences, Key2 Stories, Microsoft, SQL Server
By: Jason E Bacani BI Consultant Two weeks ago I joined my fellow colleagues from Key2 Consulting at the annual PASS Summit conference held in Seattle, Washington. Click here to see part one of my Twitter recap of the event! This article is part 2 of that...
Nov 15, 2017 | Microsoft, SQL Server, SSIS
By: Matt Wollner Sr. BI Consultant In all of the SSIS packages that we develop, we include an auditing and logging framework. This framework consists of adding Event Handlers to the package, such as OnError, OnPreExecution and OnPostExecution. ...
Nov 9, 2017 | Conferences, Microsoft, SQL Server
By: Jason E Bacani BI Consultant I was honored to be among the folks heading to Seattle to attend PASS Summit 2017, representing Key2 Consulting from November 01 – 03. Our schedule included three formal days at the conference from Wednesday through Friday,...
