Author: Aashish Patel

I am passionate about learning. I truly believe knowledge shared is knowledge gained.

How to Add Precedence Constraints in SSIS using BIML

TweetIn SSIS, tasks are linked by precedence constraints. If there are two tasks and you want them to execute in a certain order,  this is where precedence constraints are used to define the order in which they get executed in the…

SSIS Logging Template using BIML

TweetPurpose : As a BI developer you write lot of repetitive code if there are products in your company which are using same dataset but presented in different way by applying some different transformations to data or some front end changes.…

How to generate Multiple SSIS Packages using BIML

TweetAbout BIDS Helper: A Visual Studio add-in that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDTBI). The Biml Package Generator provides the ability to create packages from Business Intelligence Markup Language (Biml). Biml…

BIML Introduction

TweetAbout me: Aashish Patel. I am an enthusiastic BI Developer who is always eager to learn new technology. My skill set is within Data Warehousing using Microsoft BI Stack. I have worked in various industries (Airline , Marketing Database, Document Management…