Database Reference
In-Depth Information
}
#>
Executing the Biml File
Let's test by generating the Transact-SQL file, as shown in
Figure 20-1
:
Figure 20-1
.
Execute the FrameworkSQLGen.biml File
Right-click the FrameworkSQLGen.biml file and click Generate SSIS Packages.
The file with the filename MyFile.sql should be generated in the location contained in
the i-FrameworkSQLGen.biml include file. Open that file in SQL Server Management
Studio (SSMS) and execute the SQL statements. Your output should appear similar to
that shown in
Figure 20-2
:
Figure 20-2
.
Execute the SQL File Generated by the FrameworkSQLGen.biml File
Search WWH ::
Custom Search