Lookup is one of many transformations available in SQL Server Integration Services (SSIS). Its purpose is to perform a JOIN of two datasets: input columns from a data source and columns in a reference dataset – a table, view or a result of a query. Lookup can be used in various scenarios but this post focuses on howContinue reading “Using SSIS Lookup Transformation in ETL Packages”
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Gorandalf 