awesome. this was something that I was looking for. Adding 3rd party apps to my ETL is a little mickey mouse for me.

Thank You very much.

I am using a similar SFTP 3rd party application in one of my ODS loading SSIS package.

The problem is that the error handling is generalized and not specific.

I suggest searching...

I worked on some of the large scale fuzzy matching projects. Based on my experience you are in the right track.

You already have a table to which you load your...

Recently I happened to worked with Microsoft SSIS consultants face to face to improve one of the fuzzy matching process I have developed. But the thing is when comes to...

For something like names, i will start by using TSQL Soundex.

http://www.devx.com/enterprise/Article/43757

Fuzzy Matching Process:

If it didnt help lets try Fuzzy Matching. You can start by getting yourself friendly...

Fuzzy matching process is executed on string fields.

Unless you convert your data to string , fuzzy lookup wont allow you to perform analysis on the data.

The similarity score will...