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.
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.
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.