August 18, 2017 at 11:05 am
Here is the problem i am having and can't solve. I am learning in SSIS so be patient with me.
I have a flat file with 3 fields: DevKey, FirstName, LastName. Now, before loading this data into databse I want to check if DevKey from the file exists in the database so I add Lookup transportation that pulls DevelopmentKey out of Developments table. The problem is my Lookup returns NO MATCH when I know that there is a match. Even on the screen shots I provided you can see that there is DevKey = 247703 in both: flat file and data out of database. I researched online and figured it is probably because DevKey in the file and in the database have different datat types. DevelopmentKey in the database is integer so I changed DevKey in flat file to four-byte signed integer [DT_I4] and still no lock. I spent the whole day on this issue and can't solve this mystery. I do need to check if DevKey exists and database already and wotk only with matching records. Please help.
August 18, 2017 at 1:28 pm
I figured it out. It was simple thing that I didn't pay attention to. My lookup was set to failure if there is no match. So i changed it to redirect no match to output and all worked well. Thank you.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply