Retrieve A List Of Files From FTP Using SSIS

Retrieve a List of Files from FTP using SSIS

The FTP protocol is one of the oldest methods for sharing and moving files. Although frequently considered to be an “old-school” way to transfer data, FTP is still relied upon in most every data movement architecture. Sadly, the functionality around FTP is very limited in SQL Server Integration Services. A common project requirement is to retrieve a list of files from…

Read More

KPIs in SSRS

KPIs in SSRS 2016

Key performance indicators, or KPIs, are at-a-glance metrics for simple insight into the business. These are each designed to provide a glimpse into one aspect of a measurable business activity. KPIs are present in various implementations in most every reporting tool, including SQL Server Reporting Services. Until recently, KPIs in SSRS were not a native part of the SSRS reporting…