Database Reference
In-Depth Information
Figure 5.21
New integration services project.
Figure 5.22
Execute SQL task tool.
6. hen, click
Test Connection
and click
OK
twice to save the connection.
7. Click the box on the right side of the
SQL Statement
property, enter the following
SQL statement:
TRUNCATE TABLE ORDER_INVENTORY