SQL Server and MS BI With a Geek Touch

The video shows the dynamic functionality of SSIS packages. I have used the ETL to read through multiple excel files dynamicaaly using a single connection manager. a For each loop container is used to loop through each of these files and the data loaded into SQL database by dynamically changing the connection string for each excel file. You can also download high quality video by clicking here.

Part 1:

Part 2:

Please leave a comment with your suggestions and feedbacks.

This video takes you through the creation of SQL Server Integration Services (SSIS) project creation. The video will also demonstrate the usages execute sql tasks and will take you through various components and windows in SSIS UI and the purpose of each. you can also download high quality video from by clicking here

Let us know if you would like to watch some specific videos.

Hi all, thanks for all your comments and support. As asked by many of you, I will be uploading videos related to MS BI and sql server technology on my blog. Let me know what you think and looking forward for your suggestions.

In this video, I will demonstrate the creation of SSAS project using visual studio / BIDS. This video is mainly focused at beginners.

Cheers  — Admin