How to apply FUZZY algorithm in SSIS?

Scenario My client has a dictionary table that they're defining list of standard TV Program name. Currently, their data team must compare and match new Program with existing standard Program manually. It takes much time and efforts of the team. So they want us to provide a mechanism to help us reduce this work. For … Continue reading How to apply FUZZY algorithm in SSIS?

Advertisements

FTP Task, For EachLoop component and File System Task in SSIS

Introduction A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even we can use SSIS to download files from FTP … Continue reading FTP Task, For EachLoop component and File System Task in SSIS