Microsoft® SQL Server® 2012 Bible

818

Part V: Enterprise Data Management

You now see an SSIS package designer surface. This surface has several tabs along the top:

Control Flow, Data Flow, Parameters, Event Handlers, and Package Explorer, as shown in

Figure 31-9. This example uses the Control Flow and Data Flow tabs.

FIGURE 31-9

SSIS Package Control Flow Surface.

In SSDT, select View ➪ Toolbox. The Toolbox contains a plethora of what are called tasks,

which are control and data-fl ow elements that defi ne units of work contained and pre-

formed within a package. You use a few of these tasks to migrate the data from your local

database to your SQL Database instance.

Clearing Any Preexisting Data

Clear any data that exists in the SQL database so that you can start with a clean slate.

In SSMS, open a new query connecting to the AWMini database, and delete the data from

the Contact and Employee tables by executing the following delete statements:

DELETE FROM Employee

DELETE FROM Contact

All three of those tables should now be empty, as shown in Figure 31-10.

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

http://www.it-ebooks.info