March 27, 2008 at 12:10 am
Hello everyone,
Was wondering if this can be done. I have two source components: two comma delimited flat files. I would like to do what's very similiar to as t-SQL inner join in SSIS. Ok my two source compontnets both have an ID field. I would like to "join" on these fields and form another subset. So in other words, the matches between both files (on ID) form another subset.
The conditional split seems close, but it doesn't do what I need. It outputs another subset, but this is based on some criteria, not the matches in another source object. So is there a way to do something like this in SSIS?
What trasformation task(s) will do this or something similiar?
Thanks,
Strick
March 27, 2008 at 4:26 am
Hi,
There are 2 components that perform this functionality. One is the lookup component and the other is the merge join. The lookup component however will only work when referencing an OLE DB source, so in your case it would not work.
You're then left with the merge join. You need to sort the upstream data by Id (Use a sort component if the textfiles aren't already sorted), and ensure that the joining fields have the same datatype before it will work, but this should achieve your objective.
Kindest Regards,
Frank Bazan
March 27, 2008 at 6:26 am
Great thanks! I'm going to look into the merge join. One question though, can't a comma delimited or tab delimited text file be connected to as an oledb source? I know it can in VB 2005 using ADO.net. If I could connect to the text files in SSIS using this, I could probably get away with using your first method, correct?
Thanks,
Strick
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply