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 STAGE.dbo.NewCurrency FROM AdventureWorks_DWH.dbo.DimCurrency; ALTER TABLE STAGE.dbo.NewCurrency ADD PRIMARY KEY (CurrencyAlternateKey);
We will use the Auto correct load option to make sure that our dataflow does not insert rows already existing...