<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Posts by Shawn Harrison

Checking for SSIS File Usage with Task Factory's File Properties Task

Posted Mar 30, 2016 by Shawn Harrison

Have you ever had an SSIS package fail because a source file it reads from was opened somewhere else? This can be especially frustrating if the package in question runs after hours or on weekends. In this post, I'll demonstrate how to avoid this issue with the Task Factory File Properties Task, the Task Factory Timer Task and a For Loop container.

Using the Task Factory REST Source with GoToWebinar

Posted Feb 25, 2016 by Shawn Harrison

Today, I'm going to show you an easy way to use REST API calls to bring data into SSIS. Task Factory has a new REST Source that enables users to retrieve data from websites using the REST API. It's a rather powerful source component that can be used in a number of ways. I want to focus on general usage and how to split values into separate columns when retrieving data in JSON format.

Looping Through a Result Set with the ForEach Loop

Posted Jun 24, 2015 by Shawn Harrison

In today's blog post, I am going to show you another use for the ForEach Loop container in SSIS. Most of the time, this container is used for looping through a group of files, however, there are many different uses for it.

Creating a Simple Report with Power Query and Power View

Posted Apr 16, 2015 by Shawn Harrison

In this tutorial, I will show you how to pull data into Excel using Power Query and then put together a simple report with Power View. While you can get rather elaborate with these tools, this tutorial will begin with a simple focus. I am going to create a report that displays sales amounts from different countries over a period years.

Subscribe to Blog Updates