Skip to content

Jayanth Kurup SQL Guy

Everything SQL and More

  • Home
  • PowerBI
  • Simply Better Business
  • Business Intelligence
  • Contact Us
  • Clients and Testimonials
MSBI

Video for SSIS Starter kit

Posted on: August 11, 2015June 20, 2025

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 […]

Database / MSBI

SSIS – Starter kit for the uninitiated – Data enrichment

Posted on: August 10, 2015June 30, 2025

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 […]

Database / MSBI

SSIS – Starter kit for the uninitiated Data Flow Task

Posted on: August 7, 2015June 20, 2025

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 […]

MSBI

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

Posted on: August 7, 2015June 20, 2025

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 […]

MSBI

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

Posted on: August 4, 2015June 20, 2025

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 […]

MSBI

SSIS – Starter kit for the uninitiated – Dynamic File Paths

Posted on: August 4, 2015June 21, 2025

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 […]

MSBI

SSIS – Starter kit for the uninitiated – Web Service Task

Posted on: August 4, 2015June 21, 2025

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 […]

Database / MSBI

SSIS – Starter kit for the uninitiated – Foreachloop

Posted on: August 4, 2015June 21, 2025

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 […]

MSBI

Source Code for ETL performance test

Posted on: August 2, 2015June 21, 2025

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 […]

Database / MSBI

ETL 2 million rows – Comparison of BULK INSERT, BCP, OLEDB, ADO NET, OPEN ROWSET, SQL Server Destination task

Posted on: July 21, 2015June 21, 2025

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 […]

Posts pagination

Previous page Page 1 Page 2 Page 3 Page 4 … Page 8 Next page

Please consider following

Subscribe

Recent Posts

  • IntelliSense not working in latest version of SSMS
  • Converting times across time zones
  • SQL 2025 Optimized locking in SQL2025
  • You Can’t Be King till You’ve Killed Someone 
  • Fuzzy String matches in TSQL
Log in

Categories

  • administration
  • AI-ML
  • AWS
  • Azure
  • Database
  • Errors
  • Misc
  • MSBI
  • MSSQL
  • MYSQL
  • NOSQL
  • PowerBi
  • Security
  • TSQL
  • Uncategorized
  • Wordpress
Log in
Theme Shaft Blog Powered by Kantipur Themes