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
Смотрите видео SSIS Lookup transformations онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь goshedy 23 Декабрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,629 раз и оно понравилось 15 людям.