Database Reference
In-Depth Information
Figure 5.32
Add data conversion tool.
16. Click
Mapping
on the left-hand side of the screen, you will get the default mapping.
Take the default mapping and click
OK
.
17. Click the
Control Flow
tab and press the
F5
key. You may see a data conversion error.
In this case, click the
Data Flow
tab and drag
Data Conversion
from the Toolbox
pane to the Design pane as shown in Figure 5.32.
18. Delete the link from ADO.NET Source to OLE DB Destination and connect
ADO.
NET Source
to
Data Conversion
. Right click
Data Conversion
and select
Edit
from the pop-up menu. From the
Available Input Column
list, check
InventoryID
.
Change the data type to
Two-byte unsigned integer
as shown in Figure 5.33. hen,
click
OK
to inish the coniguration of Data Conversion.
19. Drag the green arrow from
Data Conversion
to
OLE DB Destination
to link them.
Right click on
OLE DB Destination
and select
Edit
. In OLE DB Destination Editor,
click
Mapping
. Delete the link from
InventoryID
to
InventaryID
. Add link from
Copy of InventaryID
to
InventoryID
as shown in Figure 5.34. Click
OK
to close
the dialog.
20. Click the
Control Flow
tab and press the
F5
key. If successful, both
Execute SQL
Ta sk
and
Data Flow Task
have check marks as shown in Figure 5.35.
his activity demonstrates that SSIS is another convenient data transfer tool. SSIS can
be used to transfer data in and out of Windows Azure SQL Database in various detail
levels. During the transfer, one can convert a data type and conigure the properties of a
database object.