Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSIS Lookup Component Error -"Row yielded no match during lookup"

Status
Not open for further replies.
BTrees

BTrees

IS-IT--Management
Aug 12, 2006
45
0
0
CA

I am processing/upload a simple csv file with few columns. In each column I have simple text data with no more 50 characters.
but SSIS Lookup Component Error -"Row yielded no match during lookup" for one simple column
It is confirmed that data correct and no issue with matching values.
When I tried with very small set of data (few hundred) it works but I need to upload data (any number of records like few around 3 to 4 thousands) I also tried with cache type = partial and Null but it didn't work with even 1000 no. of records. What I can try to fix this


Thanks
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Question
SSIS in SQL Server 2022
Replies
4
Views
137
grnzbra
grnzbra
grnzbra
  • Question
Editing Mappings Data Types in SSIS
Replies
0
Views
78
grnzbra
grnzbra
minhtran360
  • Locked
  • Question
Where do I look for my SSIS pasckage that just being deployed to my sql server?
Replies
1
Views
105
mark williams
mark williams
how2trainyourdragon
  • Locked
  • Question
SSIS Web Service task SSL errors
Replies
1
Views
75
how2trainyourdragon
how2trainyourdragon
Igelchen
  • Locked
  • Question
SSIS System.Text.JSON
Replies
0
Views
96
Igelchen
Igelchen

Part and Inventory Search

Sponsor

Back
Top