Database Reference
In-Depth Information
Figure 2-36.
Using a SQL statement to refine the data source
Executing an SSIS Task
Once you have created and configured an SSIS package, test your work by executing the package. To do this,
right-click the package in Solution Explorer and select Execute from the context menu, as shown in Figure
2-37
.
Executing the SSIS package may take a while as your installed SSIS service reads the underlying XML
code instructions, attempts to make the connections to the text file and the database, and then performs the
extraction, transformation, and loading tasks.
