821
Chapter 31: Managing Data in Windows Azure SQL Database
31
- Back in the Execute SQL Task Editor, click the Ellipsis button in the SQLStatement
property to display a small Enter SQL Query dialog in which to enter one or more
T-SQL statements. Enter the following DELETE statements, which clear out the data
from the previous example. (This isn’t critical, but it gives you a clean slate to start
with.)
DELETE FROM Employee
DELETE FROM Contact - In the Enter SQL Query dialog, Click OK. The Execute SQL Task Editor dialog should
look like Figure 31-13. Click OK.
FIGURE 31-13
Confi gured Execute SQL Task.- Back on the Control Flow tab in the SSIS package designer, make sure the Clear
Data task is highlighted. Notice the green arrow coming from the bottom of the
c31.indd 821c31.indd 821 7/31/2012 10:00:29 AM7/31/2012 10:00:29 AM
http://www.it-ebooks.info