The Auto correct load option is a convenient means Data Services provides for preventing the insertion of duplicates into your target table. This is the method of inserting data into a target table object inside the dataflow. It can easily be configured by setting the target table option to Yes, with no more configuration required. This recipe describes details regarding the usage of this load method.
For this recipe, we will create a new table in the
STAGE database and populate it with a list of currencies from the
DimCurrency dimension table in the
AdventureWorks_DWH data warehouse.
Execute the following statements in SQL Server Management Studio:
SELECT CurrencyAlternateKey, CurrencyName INTO ...