Row yielded no match during lookup

I am getting whay seems to be a difficult error to resolve. When running a look up task I am getting "Row yielded no match during lookup" error. I have gone through the data and resolved the following that was suggested on various message boards .

Rebuilt the whole data flow
Ltrim and Rtrim the data
Replaced Null with ''
Checked the data to make sure that case sensitivty is not an issue.

If I run the data today and then run the data a second time in the same day the lookup works fine.

Does anyone know of anything else that could be causing an issue?
earngreenAsked:
Who is Participating?
 
earngreenAuthor Commented:
I have resolved this issue it seems that the lookup taks was adding spaces at the end of the data, once I trimmed all columns in the task the issue cleared.

Thx
0
 
Jason Yousef, MSSr. BI  DeveloperCommented:
Try using "No Cache" and see if that works for you...
0
 
earngreenAuthor Commented:
Sorry I am using 2005 and not 2008
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Reza RadConsultant, TrainerCommented:
did you set the lookup to redirect no match entries as no match output in the lookup transform editor?
0
 
earngreenAuthor Commented:
That is where I am finding the errors. I redirected error rows to a table and all rows are going to the table when I know that there are matches.
0
 
Reza RadConsultant, TrainerCommented:
could you attach an screenshot from your data flow here?
0
 
earngreenAuthor Commented:
Here is a pic.
df.jpg
0
 
Reza RadConsultant, TrainerCommented:
this is not what I meant by redirect no match output,
look at attached image to find out what I meant

1.png
2.png
0
 
earngreenAuthor Commented:
I am saying that you are using SSIS 2008 and I am using SSIS 2005 where there is no such screen.
0
 
Reza RadConsultant, TrainerCommented:
sorry for late reply, could you send your package with database structures of source and destination with sample data, I try to find problem
0
 
earngreenAuthor Commented:
In using SQL 2005 SSIS, u have tof trim all data going into the lookup. No other solution provided this resolution for me.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.