SSIS fuzzy lookup issue

• ashuthinks

  SSCommitted

  Points: 1698

  More actions

  October 5, 2011 at 3:46 am

  #246074

  HI now i have id with me but in other table so now i did inner join for matching both security id and taking out companyid...

  description..

  TABLE identifier

  keyid securityid id identifier

  48712205 5033048 158976 001546AL4

  TABLE UPDATENAV

  Date SecurityId SecurityType EntryPrice Mark CompanyName

  2011-08-31 00:00:00.000 5033048 Bond 1.057500 NULL AK Steel Corporation

  2011-08-31 00:00:00.000 5049118 Bond 1.091250 NULL Aspect Software, Inc.

  NOW I HAVE DONE INNER JOIN TO GET identifier

  ALTER VIEW TempView AS

  select UpdateNAV.SecurityId ,identifier , Mark

  FROM [mydata].[dbo].[UpdateNAV] inner join dbo.Identifier

  on UpdateNAV.SecurityId = Identifier.SecurityId

  now i have used fuzzy lookup to match this.. but problem is

  I'm not able to do this correctly

  PLZ TELL ME HOW DO I CORRECTLY MAP IT.

  

• ashuthinks

  SSCommitted

  Points: 1698

  More actions

  October 5, 2011 at 4:12 am

  #1390570

  AFTER LOOKUP I TOOK OLEDB DESTINATION FOR REST MAPPING LIKE THIS>..http://social.microsoft.com/Forums/getfile/19170/

  I THERE ANY NEED OF UPDATE QUERY ???