Azure - How to create Azure SQL Database

SSIS - How to Call Multiple Child Packages by Master Package

In our day to day activities, we can build a data extraction module that can be called from different packages. 

For example, we have to load the data into a star schema, and we can build a separate package to populate each dimension and the fact table and these packages are located in some folder. They should be executed in certain order one by one.

Now, we want to create one master SSIS package that will go to that folder and grab those child packages and execute or run them one by one (no repeat) in a predefined order.

To accomplished this, You could build a Foreach Loop Container with a Package Execute Task in it to execute them, then we would need to name them so that they were retrieved in the order we wanted. 

With the help of variables, we can set the package name property in Package Execute Task and this variable will get the next value from the Foreach loop Container.

Foreach Loop Container can get these package names from a data table that contained the order we wanted and then we populate an SSIS object type variable with the record-set and use that to feed the order and the list to a Foreach loop just like we mentioned above. The only difference would be the source of the list.

The below video is capable to explain that How can we call multiple child packages by parent or master package?

SSIS - Validate Processing Flat File Format || Check Columns Name and C...

SSIS - Script Task Check if Sub-folder || Directory Exists or Not

In this tutorial, we are going to explain the functionalities of Script Task to Check if Subfolder Exists in SQL Server Integration Services. The Script task provides code to perform functions that are not available in the built-in tasks and transformations that SQL Server Integration Services provides. The Script task can also combine functions in one script instead of using multiple tasks and transformations.
For more information, please visit us at http://www.sql-datatools.com/2016/04/ssis-object-types-variable-in-execute.html

SSIS - Tracking Object Type Variables || Foreach Loop Container

In this tutorial, we are going to explain the functionalities of Object Type Variable or Custom Variables in Foreach Loop Container in SQL Server Integration Services. Variables are extremely important and are widely used in an SSIS package. A variable is a named object that stores one or more values and can be referenced by various SSIS components throughout the package’s execution.
For more information, please visit us at http://www.sql-datatools.com/2016/04/ssis-object-types-variable-in-execute.html

SSIS - How to work with Foreach Loop Container || Basics of Foreach Loop...

In this tutorial, we are going to explain the functionalities of Object Type Variable or Custom Variables in Foreach Loop Container in SQL Server Integration Services. Variables are extremely important and are widely used in an SSIS package. A variable is a named object that stores one or more values and can be referenced by various SSIS components throughout the package’s execution.
For more information, please visit us at http://www.sql-datatools.com/2016/04/ssis-object-types-variable-in-execute.html

SSRS - How to add a Polar or Radar Chart

SSRS - How to Add a Pie Chart