Biml and SSIS Frameworks - SQL Server Integration Services Design Patterns - page 496

the CmdFilename variable in the i_FrameworkSQLGen.biml file. Open the file that
was just generated and you should observe a string similar to the one shown in Listing
20-12 :
Listing 20-12 . The Command Line Generated by the GenerateExecCmd.biml File
dtexec /FILE
E:\Projects\SSISConfig2014\SSISConfig2014\Parent.dtsx
/SET
\Package.Variables[ApplicationName].Properties[Value];Staging_Application
Because this command line is contained in a “cmd” file, you should be able to
double-click it watch it execute in a command prompt window, similar to that pictured
in Figure 20-3 :
Figure 20-3 . Executing the Command Line Generated by GenerateExecCmd.biml
How cool is that?
Summarizing
In this chapter, we have extended our knowledge regarding the functionality of Busi-
ness Intelligence Markup Language. We have demonstrated how to use Biml to dynam-
ically generate Transact-SQL statements and execution command lines.