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:
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:
No comments:
Post a Comment