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?
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
Situation Yesterday, my database server was restarted because of OS update but SQL Server instance could not start. I tried to find out errors in the ERRORLOG file of SQL Server. Error messages as below 2016-12-15 11:20:28.42 Server Warning: Support for the VIA protocol is deprecated and will be removed in a future version of … Continue reading The VIA protocol issue in SQL Server