October 3, 2014 at 10:43 am
I'm sorry if this is not the best spot for this question, but I couldn't find an forum that looked more relevant.
Currently, I am using T-SQL to combine some data and using an ISNULL function like this:
,ISNULL(H.Last_Name, S.PatientLastName)
,ISNULL(H.First_Name, S.PatientFirstName)
I am wanting to change from using a query to move this data to using an SSIS Data Flow. I am familiar with using Merge Join to combine the two tables (H & S in this case), but I'm not sure where I can use the ISNULL in the manner described above. Is there a way to do it in the Merge Join? Do I have to do it after the Merge Join? Anyone ever done this?
Thanks!
October 3, 2014 at 11:00 am
You would have to do this in derived column component after the merge join if you were to do it in SSIS. I'd suggest leaving it in SQL Server, because I'm pretty confident that it will perform better.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 3, 2014 at 12:27 pm
Thanks Jack, I appreciate the help. Unfortunately, the two tables are on different servers and the admins of one of them is insisting that I do not use linked tabled to that server in any queries. So I was going to just use SSIS to pull the data from the two sources independently and join them.
I will play with it and see how it performs.
Thanks again.
October 3, 2014 at 12:34 pm
I was assuming it was on a single server. If it requires a linked server I'd go with a solution in SSIS.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply