Sergiy (2/24/2016)

---

First, you need to replace this strange piece of code:

LEFT join ADW.DIM.Modality M

ON SO.ModalityCode = M.ModalityCode

JOIN ADW.dim.Department D

ON D.DepartmentID = CASE WHEN M.departmentID is null...

Well Here's the solution I came up with.

I created a new data connection to the existing source directory and use that in the move file task along with the variable...

Yep. I added a break point and checked the variables and the filename, source, archive etc... all looked as I would expect.

Jason A. Long (9/1/2015)

---

craig.bobchin (9/1/2015)

---

Jason,

That works great. I've been fooling around with the thresholds to try and get the best match before I present it to the business. I also...

Jason,

That works great. I've been fooling around with the thresholds to try and get the best match before I present it to the business. I also made a couple of...

Jason A. Long (8/31/2015)

---

craig.bobchin (8/31/2015)

---

Thanks Jason, I do actually have the fields in the table, I just copied the earlier version of the create table script for dimMembers.

I'll check the...

Jason A. Long (8/31/2015)

---

See what you think of this...

-- Add the two new columns to dimMember...

--ALTER TABLE dbo.dimMember ADD GroupID INT;

--ALTER TABLE dbo.dimMember ADD MatchQuality INT;

IF OBJECT_ID('tempdb..#MatchScores') IS NOT NULL...

Sorry, Here it is:

INSERT INTO [dbo].[dimMember]

...

Jason A. Long (8/28/2015)

---

craig.bobchin (8/28/2015)

---

Jason,

I modified your code for our table/fields and it doesn't quite work. I set the threshold to >=4 and of the 30k records in the table...

Jayanth & Jason, I am out of town this weekend, and will give your suggestions a try when I get back to the office on Monday. Thanks

Jason A. Long (8/27/2015)

---

The code I posted earlier shows how to handle the "how to assign a common value to a new field based on the matches" problem.

The idea is...

Jayanth_Kurup (8/27/2015)

---

I think your looking at the problem the wrong way. using t-sql to do fuzzy lookups is kind of tricky since the db is not really suited to doing...

Jayanth_Kurup (8/27/2015)

---

I think your looking at the problem the wrong way. using t-sql to do fuzzy lookups is kind of tricky since the db is not really suited to doing...

Jeff Moden (8/27/2015)

---

craig.bobchin (8/27/2015)

---

ScottPletcher (8/27/2015)

---

To me it seems fairly easy to match single rows. Maybe you can just output those matches to a table and then consolidate the like...

ScottPletcher (8/27/2015)

---

To me it seems fairly easy to match single rows. Maybe you can just output those matches to a table and then consolidate the like ids using that...