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.