Yes, My bad, sorry for not being clear.

Phil, Like Drew pointed out, your solution returns formulas that have even ONE ingredient in common, while I am looking for a exact match on ALL ingredients. I appreciate your...

Drew,Thanks for your reply. I see that you have sorted the ingredients and this might work. let me try it out.

Chris, sorry, yes I just saw it. i had the browser open and didn't refresh before posting the reply. I think that would work. I am trying it now to...

It's too late for that. I have coded many packages using these techniques. Just need to change the way the connection to server is done. It would help me a...

I need to connect to it in a script task. I need to do some processing on the data and save it to other tables. I do need to do...

Can you give me some code without using dynamic SQL for this?

Nope, this is not homework. I did look at sp_executesql but could not get it to work. How would I assign this variable the value I need from the dynamic...

add a vbscript task before the actual import and open the csv file and delete the last 2 rows and save the file. Then import it and you should be...