Using Convert SSIS package to Biml
The sample DailyETLMain.dtsx
SSIS package for the WideWorldImporters
solution first has three tasks that precede a list of Sequence Containers
, and they are quite basic. So, instead of going over the Biml to create them, which we have already covered in previous recipes, let's demonstrate one helpful functionality in BimlExpress that can be a great learning tool as well – it is the option to Convert SSIS Package to Biml.
What we want to accomplish in this recipe is to do the opposite of what we were doing in previous recipes and to generate Biml code from an existing SSIS package.
Getting ready
Open Visual Studio 2019, and then open the ETLInAzure SSIS project.
How to do it…
Add a new Biml file to your solution and rename it to Recipe5.biml
. Copy the code from Recipe4.biml
to the new Biml file because it will be our starting point:
- Change the name of the package in the Package element to
Recipe5
. - Right...