Generate Format Files Based on Table Metadata

Recently I had blogged about advantages of using format files in bcp to generate custom formatted output files.http://visakhm.blogspot.in/2013/10/bcp-out-custom-format-data-to-flat-file.htmlI got lot of responses on this post and many of them were asking whether there’s any easy way to generate a format…

Using SSRS to Export SQLServer data to multiple Excel Sheets

Last week I had blogged about how to export SQL Server data to multiple sheets of an Excel file using SSIShttp://visakhm.blogspot.in/2013/09/exporting-sqlserver-data-to-multiple.html One of my readers asked me whether we could achieve this using any other method. There’s a much easier…