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 […]
Source Code for ETL performance test
There was a lot of response on the ETL performance test that was published last week so I have published the source code for all the tests at […]
ETL 2 million rows – Comparison of BULK INSERT, BCP, OLEDB, ADO NET, OPEN ROWSET, SQL Server Destination task
A quick video comparing the performance of different ETL options when importing 2 million rows into a database. All tasks use the BULK Logged Options where possible. ETl […]
Why I don’t have a lot of personal info on the internet- OLAP – BIGDATA and the future of privacy
I was asked this question while having a chat with a few friends. Mainly the complaint was I don’t have a lot of social media presence. The only […]
You can now create nonclustered indexes on the Clustered Columnstore index
This post is to correct a mistake I made in my previous post on Updateable Non Clustered Columnstore index in SQL 2016; in that post I mentioned that […]
SQL 2016- Live Query Stats
I am a bit confused about this feature so I thought I would post about it to get feedback on its usage in SQL 2016. With SQL 2016 […]