SSIS Lookup transformations
After you have configured the Flat File source to extract data from the source file, you define the Lookup transformations needed to obtain the values for CurrencyKey and DateKey. A Lookup transformation performs a lookup by joining data in the specified input column to a column in a reference dataset. The reference dataset can be an existing table or view, a new table, or the result of an SQL statement. In this tutorial, the Lookup transformation uses an OLE DB connection manager to connect to the database that contains the source data of the reference dataset.
In this task, you add and configure the following two Lookup transformation components to the package:
One transformation that does a lookup of values from the CurrencyKey column of the DimCurrency dimension table, based on matching CurrencyID column values from the flat file.
One transformation that does a lookup of values from the DateKey column of the DimDate dimension table, based on matching CurrencyDate column values from the flat file.
In both cases, the Lookup transformation uses the OLE DB connection manager you previously created.
SSIS Lookup transformation Guide
https://learn.microsoft.com/en-us/sql...
follow me on / goshedy
/ goshedy
/ goshedys
#SSIS #lookup #transformation #OLDDBConnectionManager
Video Chapter
0:00 Introduction-SSIS Lookup transformations
01:36 Lookup Transformation from result of an SQL query
08:20 Lookup Transformation from a Table or View
Watch video SSIS Lookup transformations online without registration, duration hours minute second in high quality. This video was added by user goshedy 23 December 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,629 once and liked it 15 people.