Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Sunday, 22 June 2014

How to join Two Tables Using Lookup Task in SSIS 2012.

Hi,

We have two table Product and ProductCostHistory both matches with Productid

T-SQL:

Select pch.ProductID,p.Name,pch.StandardCost,p.ProductNumber from AdventureWorks.Production.Product p
join AdventureWorks.Production.ProductCostHistory pch on p.ProductID=pch.ProductID

How to achieve using Lookup Task in SSIS?

SSIS flow of above task see below: