Database Reference
In-Depth Information
5.
In the Connection Manager dialog, enter the server name of your SQL Azure
server, select Use SQL Authentication, and enter your SQL Azure username
and password. The username must be in the format
username
@
server
where
username
is your Administrator username or a valid SQL Azure username and
server
is the first part of the server name (the piece prior to
.database.windows.net).
6.
In the “Select or enter a database name” field, the OLE DB provider doesn't
return a list of databases. No big deal: type in the name
TechBio
.
7.
Click the Test Connection button. If you've entered everything correctly and
your firewall is set up, your test connection succeeds.
8.
Click OK in the Connection Manager dialog.
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 UserDocs
DELETE FROM Users
DELETE FROM Docs
10.
9.
Click OK in the Enter SQL Query dialog. The Execute SQL Task Editor dialog
should look like Figure 5-11. Click OK.
Figure 5-11.
Execute SQL Task Editor
