Tag Archives: file

Suspect MSDB and no Backups

By | September 18, 2015

Yesterday I got a call from a client about MSDB being suspect after a drive failure. Unfortunately the client didn’t have any backups. Now the correct and best option is to use a backup and restore the database. This way you don’t lose any of the jobs and other configurations that you may have set… Read More »

SSIS – Starter kit for the uninitiated Data Flow Task

By | August 7, 2015

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 we got till this step please click here. Step Screenshot Double Click and open the DFT we had added in the previous post. Drag and Drop an… Read More »

SSIS – Starter kit for the uninitiated Foreachloop – for each file enumerator

By | August 7, 2015

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 the database. To achieve this I am going to use the foreach loop container once more and this time use the for each file enumerator. Step Screenshot… Read More »

SSIS – Starter kit for the uninitiated – Execute process task and PowerShell

By | August 4, 2015

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 mandatory in most cases where the XML is well formed, in this particular example we see an issue with the file. Namely < And > text is… Read More »

SSIS – Starter kit for the uninitiated – Dynamic File Paths

By | August 4, 2015

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 to store the output of our web service task. Navigate to the connection managers in the bottom pane of SSIS and right click the Connection manager we… Read More »

SSIS – Starter kit for the uninitiated – Web Service Task

By | August 4, 2015

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 Link for Airport Information, it will take you to the below screen where you can find the URL for the web service.   Click the URL to… Read More »

SSIS – Starter kit for the uninitiated – Foreachloop

By | August 4, 2015

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 and PowerView to display this information in a clean and concise way. This need was so powerful that I spent the next 4 hours writing an SSIS… Read More »