Couple of days before I was replicating out a logic in SSIS from T-SQL and I was in for a surprise. I’m sharing it through this blog post for others benefit.I’d blogged sometime back on how to develop server independent…
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…
BCP Out Custom Format Data to Flat File
One of the frequent requirements that I have come across in most of the ETL projects which I’ve undertaken is the ability to transfer data from and to flat files. The usual way to implement this was by designing a…
Different ways to export SQL Server data to text file
This blog explains few methods you can use to export data from SQL Server table to a text file. Consider the below table as an illustration The requirement is to export data to a text file.Now lets see different ways…
Creating and Deploying Azure based Report
This blog post explains the step by step procedure for creating a sql report based on azure datasource and host it on a azure based reporting server.I’ve an azure instance where I’ve created a database to store some data which…
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…