Database Reference
In-Depth Information
11.
Back on the Control Flow tab in the SSIS package designer, make sure the
Clear Data task is highlighted. Notice the green arrow coming from the bottom
of the Clear Data task: click anywhere on this green arrow, and drag it to the
first data flow task. Doing so creates a connection from the Clear Data task to
the first data flow task, signifying the flow of execution. You can see an
example of this in Figure 5-14.When the Clear Data task has completed
executing, the first data flow task will then execute.
12.
Let's add logic to the first data flow task. Double-click the linked data flow task
(or right-click and select Edit). Doing so takes you to the Data Flow tab.
13.
Drag an OLE DB Source task and an OLE DB Destination task to the Data Flow
designer surface. This is where the actions of pulling data from the source
database (the local DB) and copying it to the destination database (SQL Azure)
take place.
14.
Right-click the OLE DB Source task, and click Edit. Doing so opens the OLE DB
Source Editor, where you define a connection to your local database, such as
the connection shown in Figure 5-10. You already have a connection to the
SQL Azure database, but you need to create a connection to your local
database that your tasks use to copy the data.
15.
On the OLE DB Source Editor task, you see the connection to the SQL Azure
database. Click the New button to open the Configure OLE DB Connection
Manager dialog. Click New again to open the Connection Manager dialog you
saw in Figure 5-10.
16.
In this dialog, enter the information to connect to your local copy of the
TechBio database.
17.
Test the connection, and then click OK in the Connection Manager dialog.
18.
Click OK in the Configure OLE DB Connection Manager dialog.
19.
Back in the OLE DB Source Editor, click the Table/View drop-down, select the
Docs table, and then click OK.
20.
As you did for the control flow task, drag the green arrow from the OLE DB
Source task to the OLE DB Destination task.
21.
Double-click the OLE DB Source task to edit the task properties, which is
where the data is going: the SQL Azure database. Because you've already
created a connection to the SQL Azure database, you can use that connection.
In the OLE DB Destination Editor, select the SQL Azure connection, and then
select the Docs table from the drop-down list of tables. Oops—you get the
error shown in Figure 5-12.
