Exploring the Auto correct load option

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.

Getting ready

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 ...

Get SAP Data Services 4.x Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.