
178 ◾ Cloud Database Development and Management
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 ...