ReportDr00
IS-IT--Management
Hello
I have Sql server source and sql server destination and i have look up transformation between them.
The source is query below
Select LastName,FirstName,DOB,SSN From User
In Look up transformation i connect to different server and do a query below
Select UserID from User Where LastName=? AND FirstName=? and DOB=? and SSN=?
and if match is found send UserID to destination where it gets loaded on sql server table.
When i ran the task, it does the look up and then it write 0 rows in destination and i dont know why. I know there are lot of matches that needs to be inserted into destination.
But i dont know why it is not writing anything into destination.
Any help is greatly appreciated
I have Sql server source and sql server destination and i have look up transformation between them.
The source is query below
Select LastName,FirstName,DOB,SSN From User
In Look up transformation i connect to different server and do a query below
Select UserID from User Where LastName=? AND FirstName=? and DOB=? and SSN=?
and if match is found send UserID to destination where it gets loaded on sql server table.
When i ran the task, it does the look up and then it write 0 rows in destination and i dont know why. I know there are lot of matches that needs to be inserted into destination.
But i dont know why it is not writing anything into destination.
Any help is greatly appreciated