Generating a basic SSIS package
Now we are ready to get to SSIS packages. Let's start with an SSIS package that is similar to a master package, because that type of package is best suited to automation. Master packages are usually simple and call other packages in a linear manner. We will use a Wide World Importers sample SSIS project for this recipe. In the Wide World Importers sample project, DailyETLMain.dtsx is a single package, and it contains a set of Sequences for each destination table. Each sequence has more logic in it. All we want to do in this recipe is to generate an SSIS package with a collection of empty Sequence Containers for each destination table.
Getting ready
There are a couple of steps we need to take before beginning:
- Open Visual Studio 2019 and then open the ETLInAzure SSIS project. First, we will need to prepare our driving force: metadata. You will need to create a new SQL Server database,
BIMLMetadata, where the metadata and configuration...
