819
Chapter 31: Managing Data in Windows Azure SQL Database
31
FIGURE 31-10
Verifying Empty Contact and Employee Tables.Building a Migration Package
Now it’s time to start building an SSIS package to migrate your data. Follow these steps:- In the SSIS package designer, select the Control Flow tab, and drag an Execute SQL
task and two data fl ow tasks from the Toolbox onto the Control Flow Designer. - Right-click Execute SQL task, and from the context menu, select Edit. The Execute
SQL Task Editor opens. - Change the task name to Clear Data, leave the Connection Type as OLE DB, and
leave the SQLSourceType as Direct Input. - In the Connection property, select
, as shown in Figure 31-11. The
Confi gure OLE DB Connection Manager dialog opens, which lists the current connec-
tions defi ned for the package. This list will be empty because there are no defi ned
connections; thus, you need to defi ne a new connection by clicking the New button
to open the Connection Manager dialog (see Figure 31-12).
FIGURE 31-11
Creating a New Connection.c31.indd 819c31.indd 819 7/31/2012 10:00:27 AM7/31/2012 10:00:27 AM
http://www.it-ebooks.info