Codementor Events

How and why I built Extract data of more than 100 tables to text files.

Published Nov 29, 2020

About me

SSIS and Data warehouse Developer.

The problem I wanted to solve

Developing ETL for tables to extract data into text files but dynamically means that by writing BIML Script.

What is Extract data of more than 100 tables to text files.?

BIML is Business Intelligence Markup Language to build SSIS ETL dynamically.

Tech stack

I used SSIS, SQL Server and BIML.

The process of building Extract data of more than 100 tables to text files.

First I create a meta data base in which the name of the tables , its column are stored for which I need to extract data. Then I write a stored procedure that give me the select statement against all the tables for data selection. Then I build SSIS ETL dynamically using BIML.

Challenges I faced

Need to understand BIML.

Key learnings

Building SSIS ETL Dynamically with less effort and saves time.

Tips and advice

Final thoughts and next steps

Discover and read more posts from Zakir Hussain
get started