Database Reference
In-Depth Information
Connect a data flow path between the source and destination adapters, edit the des-
tination, and map the columns.
The last step is to update the LoadMetrics table in the MASD database. To accom-
plish this update, add an Execute SQL task to the control flow and rename it appropri-
ately and descriptively. I named mine Update AndyWeather LoadMetrics Table and
configured it to use ADO.Net to connect to my MASD database. My query looks like
this one shown in Listing 14-4 .
Listing 14-4 . Updating the Azure SQL Database LoadMetrics Table
Update dbo.LoadMetrics
Set MetricIntValue = (@MaxID + 1)
, LoadDate = GetDate()
Where MetricName = 'CleanTempMaxID'
Map the value of CleanTempLocalMaxID into the @MaxID parameter on the
Parameter Mapping page. And that's it. This script makes the current maximum ID the
minimum ID of the next load.
Conclusion
In this chapter we examined aspects of the architecture and design for loading cloud
destinations. We designed a sound solution after weighing the architectural and eco-
nomic considerations.
 
 
Search WWH ::




Custom Search