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.
Search WWH ::




Custom Search