Author : Erik Hudzik

Problem Connecting to Remote SQL Server – “doesn’t support requested protocol”

Mar 26, 2017 | Erik Hudzik

Problem After installing a new named instance of SQL Server 2016 onto a development machine, I was unable to connect via a remote machine, but could connect locally. The named instance, MSSQLSERVER2016, was the 2nd…

Setting Up a Raspberry Pi 3 as a Print Server

Feb 21, 2017 | Erik Hudzik

Since the dawn of the digital age, man has been trapped in a never ending struggle with printers. Total disaster. I hate printers. But this post isn’t about ranting about how terrible printers are in…

BIML Part III - BIML Script and Custom Metadata Tables for Dynamic ETL Frameworks

Feb 15, 2016 | Erik Hudzik

Using BIML, BIML Script and existing metadata, such as INFORMATION_SCHEMA.TABLES, to dynamically generate SSIS packages can be very useful. Even more useful is the ability to create your own metadata tables which can be used as…

Extract Multiple Access DBs (with different schemas) via SSIS Script Task into SQL Server

Jan 18, 2016 | Erik Hudzik

        * If you want to skip straight to the C# sample code, click here.   Problem:   We’ve all heard it before – “Well I get the crucial financial numbers from…

BIML Part II - Adding BIML Script to Automate SSIS Package Generation

Dec 30, 2015 | Erik Hudzik

In my last post we went through a quick introduction to BIML – AKA Business Intelligence Markup Language.  We used it, and the help of BIDS Helper, to generate a very basic SSIS package simply…

Introduction to Business Intelligence Markup Language (BIML)

Nov 2, 2015 | Erik Hudzik

Business Intelligence Markup Language, or BIML, is a dialect of XML that describes Business Intelligence objects such as ETL Packages, Cubes, and even Facts and Dimensions (here we will focus mainly on ETL Packages).  This…

Select and Process Multiple Dimensions at Once in SQL Server Management Studio

Mar 3, 2015 | Erik Hudzik

Select and Process Multiple Dimensions at Once in SQL Server Management StudioWhat if you want to process multiple dimensions on an SSAS db but you don’t want to go through the process of scripting out…

Having an SSIS Component “Wait” Until a Condition is met or a Time Period Passes

Nov 10, 2014 | Erik Hudzik

Having an SSIS Component “Wait” Until a Condition is met or a Time Period Passes*If you just want the best solution and not the discussion, scroll to the bottomBackgroundFor a recent project, my colleague (@craigblevin)…

Random, Repeatable, Sampling of Dimension and Fact Records with SQL Server

Jan 26, 2014 | Erik Hudzik

Sometimes while you are first building and populating a data warehouse, or after it is populated with millions of records, you may want to get a better sampling of records to review instead of a…