Database Reference
In-Depth Information
8.
Locate the C:\_Bisolutions\Publicationsindustries\PublicationindustriesETLCode.sql
file; highlight it with your mouse, and then click the Add button at the bottom of the
dialog (Figure
7-41
). The new file is placed in a Miscellaneous folder as part of the
ssis project.
Figure 7-41.
Adding the Publication Industries ETL Code.sql file to your SSIS project
9.
once the sQL code file has been added to your project, right-click the file and select
the open with option from the context menu. This opens the open with dialog, as
shown in Figure
7-42
.
10.
in the open with dialog, note the choice of editing tools avaliable.
11.
select Transact-sQL Editor, and click the oK button.
