Excel spreadsheets are useful for distributing data generated by SQL Server. EPPlus is an open source .NET library that reads/writes Excel 2007/2010 files using the Open Office XML format (XLSX). It is a mature project, and plays well with SSIS.
By Stan Kulp
2016/01/22 (first published: 2014/02/11)
integration services (ssis)