Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssis do you need a path for both lookup outputs? Expand / Collapse
Author
Message
Posted Tuesday, July 31, 2012 3:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, January 15, 2014 4:42 AM
Points: 278, Visits: 551
I am relatively new to ssis although i am getting better :)

I seem to struggle with lookups tho, a lot of the time i get the "lookup doesnt yeild a match" error when i am pretty sure it does

is this because i am not giving both match and no match outputs?
Post #1337755
Posted Tuesday, July 31, 2012 1:41 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:21 AM
Points: 285, Visits: 768
erics44 (7/31/2012)
I am relatively new to ssis although i am getting better :)

I seem to struggle with lookups tho, a lot of the time i get the "lookup doesnt yeild a match" error when i am pretty sure it does

is this because i am not giving both match and no match outputs?


I would say no. The outputs should have no impact on "matchedness."

when you have records that didn't match, but you feel that they should, use the data viewer to trap the exact info coming down the flow. You may find that you need to trim strings or convert numbers, etc., in order for a true match to occur.

Post #1338141
Posted Tuesday, July 31, 2012 3:15 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:16 PM
Points: 2,812, Visits: 2,543
I agree that you should pay attention to leading and trailing spaces, in particular trim all of your text type columns. Where SQL Server will usually ignore those spaces, SSIS is basically a .Net product and much pickier about these sorts of things. I make it a rule to trim pretty much all text data regardless of source, and that would include trimming the query that loads your lookup as well.
Post #1338203
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse