Database Reference
In-Depth Information
ACTIVITY 5.4 EXPORTING DATA FROM WINDOWS
AZURE SQL DATABASE USING SSIS
As an example, we will export data from the table ORDER_INVENTORY in the database
Computer_Store hosted by Windows Azure SQL Database to the same table in the database
Computer_Store hosted by the local SQL Server with SSIS. In SQL Server 2012, SSIS is
included in SQL Server Data Tools.
1. To start SQL Server Data Tools, press the
Windows Icon
key and click the icon of
SQL Server Data Tools (
Version 2010) as shown in Figure 5.20.
2. To open a new project dialog, click
FILE
,
New
, and
Project
. After the new project dia-
log is opened, in the
Installed Template
pane, select
Business Intelligence
and select
Integration Services Project
from the Templates pane. Enter
ImportFromCloud
as
the project name (Figure 5.21). Click
OK
to create the project.
3. Expand the
Toolbox
on the left-hand side of your screen. In the Toolbox pane, drag
and drop the
Execute SQL Task
onto the Design pane as shown in Figure 5.22.
4. Right click the
Execute SQL Task
and select
Edit
. On the General page, click the box
next to
Connection Type
, select
ADO.NET
. Also, click the drop-down list on the right
side of the
Connection
property and select
New Connection
as shown in Figure 5.23.
5. To create a connection to an SQL Server instance, click the drop-down list on the
right side of the
Connection
property and select
New Connection
. When the con-
nection dialog opens (Figure 5.24), the name of the SQL Server is your Windows
Azure SQL Database server. For the authentication method, use the
Use SQL Server
Authentication
option. Enter your Windows Azure SQL Database login information.
hen, select the database
Computer_Store
.
Figure 5.20
Open SQL Server data tools (Version 2010).