SQLTeam.com | Weblogs | Forums

SSIS, Range Linking in LookUP Tranformation


#1

Hi Guys,

Can someone help me in SSIS,

Here I have Flat File Source and .CSV Destination. In Between, I want to use something like this.

Select
Table1.StartDate
,Table1.EndDate
,Table2.Phone
,Table2.Address
from dbo.Table1
Inner join Table2 on Table1.ID = Table2.ID
Where
Table2.Phone = FlatfileSource.Phone
and FlatfileSource.Date between Table1.StartDate and Table1.EndDate

Note:- FlatFileSource is my Raw File data source in SSIS

My question is, How can I use range syntax in SSIS. I don't think I can use Merge Join. However, I think I can use Lookup
transformation. Please help me out to accomplish above SQL to get Table2.Address from SQL Table.

Please let me know if my question is not clear.

Thank You.