Got official mail regarding my renewal fourth time in a row as MVP. Nice way to start the new year. Thanks for all who have been supporting and encouraging me in all my endeavours.May this new year bring all goodness…
Selective File Archiving using SSIS
File Archiving is one of the major maintenance tasks in every database. There are numerous occasions where data transfer happens in the form of files (xls,csv etc) so there has to be an efficient archiving mechanism as a part of…
Different ways to implement date range comparison logic in Transact SQL
There are multiple ways of implementing date range comparisons in Transact SQL. The purpose of this post is to explain one of the efficient ways by which we can implement date range comparison. The impetus for this post was the…
Implementing dynamic secure FTP process using SSIS
This blog post explains one of the approaches for automating file export/import between a remote secure FTP site and local folder. This is one of the common scenarios which we come across when data transfer has to be take place…