검색
검색

Why does SSIS lookup return null value?

debugcn 에 게시 Dev
12
Neko069

I'm having an issue with a SSIS Lookup component. My source table has a string value (XXX), and I need to know if it exists on another table. If I make a query like

select AAA from dest_table where AAA = XXX

I DO get a matching result. This value does exists in both tables. But when I use a Lookup component, it doesn't find any matches and returns NULL (and this leads to a crash in all the next steps of my package). My lookup query is:

select AAA, BBB from dest_table group by AAA, BBB

I need BBB value for following ETL processes. Plus, I added a Multicast component so I can lead all the results I got from the lookup to a testing table, and at the same time let the package flow continue its course. And this testing table only has null values inside (meaning lookup didn't find a match)

What can be the reason behind this?

Thanks in advance!

Neko069

Ok guys, after several tries, I still cannot find out why is this happening. However, I'll be bypassing this with a simple SQL Task component, with the same query that lookup component has. This doesn't give any errors, don't know why...thanks anyways!

이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.

침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제

에서 수정
0

몇 마디 만하겠습니다

0리뷰
로그인참여 후 검토

관련 기사

분류에서Dev

Why does this MySQL stored function return null?

분류에서Dev

Why does a void function return a value?

분류에서Dev

Why does UserManager.FindById() return null if I do not relog?

분류에서Dev

Why does scala return an out of range value in this modulo operation?

분류에서Dev

Why does new $class; return null when class_exists($class) returns true?

분류에서Dev

why nextelementsibling return null | dom traversing js

분류에서Dev

When does Class#getClassLoader return null?

분류에서Dev

Sub Query - Return NULL, if it does not match the highest

분류에서Dev

Why does SomeStruct() is AnyObject return true?

분류에서Dev

Why does an async method not return the awaitable immediately?

분류에서Dev

Why does egrep -o not return the entire match?

분류에서Dev

Why does my JavaScript instances return the same?

분류에서Dev

Why does this MySQL XOR query return 0?

분류에서Dev

Why does stripslashes not return the data without a slash?

분류에서Dev

Why does the error method return an error?

분류에서Dev

C++ does not want a return value

분류에서Dev

Why does 'return' and 'yield return' have the same behaviour in this example?

분류에서Dev

Why does this SQL order null values last?

분류에서Dev

Why does monkeypatch not recognize an assignment value in the constructor?

분류에서Dev

Why does NSDate() store a strange value in CoreData

분류에서Dev

Return the first non-NULL value in the list, or NULL if there are no non-NULL values

분류에서Dev

Php recursive function return null while variable have value

분류에서Dev

Why does the MBR return a different offset than Ubuntu's commands?

분류에서Dev

Why does indexing bytes in Python 3 return an int instead of bytes?

분류에서Dev

Why does the print(f.close()) return None in the following code?

분류에서Dev

Why does crypto.subtle.digest return an empty Object

분류에서Dev

Why does iwlist scan return cached results almost every time?

분류에서Dev

why this way return an instance of my object correctly, but this way does not

분류에서Dev

PHP Why does the DateTime diff function always return zero?

Related 관련 기사

  1. 1

    Why does this MySQL stored function return null?

  2. 2

    Why does a void function return a value?

  3. 3

    Why does UserManager.FindById() return null if I do not relog?

  4. 4

    Why does scala return an out of range value in this modulo operation?

  5. 5

    Why does new $class; return null when class_exists($class) returns true?

  6. 6

    why nextelementsibling return null | dom traversing js

  7. 7

    When does Class#getClassLoader return null?

  8. 8

    Sub Query - Return NULL, if it does not match the highest

  9. 9

    Why does SomeStruct() is AnyObject return true?

  10. 10

    Why does an async method not return the awaitable immediately?

  11. 11

    Why does egrep -o not return the entire match?

  12. 12

    Why does my JavaScript instances return the same?

  13. 13

    Why does this MySQL XOR query return 0?

  14. 14

    Why does stripslashes not return the data without a slash?

  15. 15

    Why does the error method return an error?

  16. 16

    C++ does not want a return value

  17. 17

    Why does 'return' and 'yield return' have the same behaviour in this example?

  18. 18

    Why does this SQL order null values last?

  19. 19

    Why does monkeypatch not recognize an assignment value in the constructor?

  20. 20

    Why does NSDate() store a strange value in CoreData

  21. 21

    Return the first non-NULL value in the list, or NULL if there are no non-NULL values

  22. 22

    Php recursive function return null while variable have value

  23. 23

    Why does the MBR return a different offset than Ubuntu's commands?

  24. 24

    Why does indexing bytes in Python 3 return an int instead of bytes?

  25. 25

    Why does the print(f.close()) return None in the following code?

  26. 26

    Why does crypto.subtle.digest return an empty Object

  27. 27

    Why does iwlist scan return cached results almost every time?

  28. 28

    why this way return an instance of my object correctly, but this way does not

  29. 29

    PHP Why does the DateTime diff function always return zero?

뜨겁다태그

보관