It’s warm, fuzzy and brings similar data together helping correct typos, different titles for the same role and much more. Today I present a short video explaining how […]
Video for SSIS Starter kit
A video explaining all the tasks (control flow and data flow) for the SSIS series for beginners. https://www.youtube.com/watch?v=zrarG-cU4RQ Here is the list of blogposts that contain the complete […]
SSIS – Starter kit for the uninitiated – Data enrichment
In this last post (after which there will be a video explaining how to bring all this together in Power view) I cover how to convert geo coordinates […]
SSIS – Starter kit for the uninitiated Data Flow Task
In this post we explore how to use the DFT (Data Flow Task) to load data from an XML file into the database. For previous post on how […]
SSIS – Starter kit for the uninitiated Foreachloop – for each file enumerator
In this post we continue from where we left off in the last post, with the xml files now formatted properly it’s time to load the data into […]
A simple change that could save Millions of $$$ in Support services
I recently came across the below error message “An exception was thrown by Target of invocation” What it really means is the application you tried to run […]
SSIS – Starter kit for the uninitiated – Execute process task and PowerShell
In this fourth part of the series (see previous post here) we proceed to modify the XMl files downloaded from the web service. While this step is not […]
SSIS – Starter kit for the uninitiated – Dynamic File Paths
Continuing from our previous post here we explore how to configure tasks to behave dynamically. More specifically how to configure the file connection manager to accept dynamic paths […]
SSIS – Starter kit for the uninitiated – Web Service Task
Continuing from the last post, we now configure the web Service task. If you visit the web service link you will see the below screen “http://free-web-services.com/web-services/geo/location-info/“ Click the […]
SSIS – Starter kit for the uninitiated – Foreachloop
I was up at 3:00 AM in the morning and felt that the world needs to know where all the airports are and how you could use SSIS […]