Microsoft® SQL Server® 2012 Bible

817

Chapter 31: Managing Data in Windows Azure SQL Database

31

replied that SSIS relies on SQL Server Management Objects (SMO) for this task, and SMO

currently support a limited subset of SMO functionality in SQL Database. In addition,

some of the SSIS connection managers use SMO and therefore are limited when dealing

with objects. Thus, the current solution is to create databases and tables using straight

SQL and then use SSIS to do the actual data transfer. The following section illustrates

how to use SSIS to migrate your data from on-premise SQL to SQL Database.

As with the rest of the items in this chapter, you’ll be using SQL Server 2012 features, and in SQL Server 2012,

Business Intelligence Development Studio (BIDS) has been renamed to SQL Server Data Tools (SSDT).

Creating an Integration Services Project

To create your project, follow these steps:

1. Fire up SQL Server Data Tools by choosing Programs ➪ Microsoft SQL Server
   2012 ➪ SQL Server Data Tools.


2. When SSDT opens and the New Project dialog displays, expand the Business
   Intelligence node and the list of installed templates, select the Integration Services
   template type, and then select Integration Services Project, as shown in Figure
   31-8. Click OK.

FIGURE 31-8

Creating an Integration Services Project.

c31.indd 817c31.indd 817 7/31/2012 10:00:27 AM7/31/2012 10:00:27 AM

http://www.it-ebooks.info