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…
Exporting SQLServer data to multiple sheets of Excel file
There was a requirement in one of my recent projects to export data from table in SQLServer database to an Excel file. Though it sounds a straightforward one, there was a tricky part in it. The data has to go…
Connecting to Azure Instance using SSIS
This blog post discusses two methods in SSIS which can be used for connecting to Azure instances.The attempt is to copy an on premise table along with the data to an Azure instance.We can use ADO.NET connection manager to connect…
Implementing Transaction over File System Objects
Its a common scenario in ETL processes to transfer files from remote location to landing folder and do some processing with them. Recently we had a requirement wherein we were asked to implement transaction processing for the file transfer package.…
DTExec issues in multi instance SQL Server box
The purpose of this blog is to highlight a problem which I faced while automating an ETL process recently and to suggest a solution for it.The scenario was as follows.There were a set of packages which were developed in SSIS…
Export SQL server data to dBase files
Previously I’d blogged on importing the data from dBase (DBF) files to a SQL Server table which can be found in link below http://visakhm.blogspot.in/2013/08/importing-dbf-files-to-ssis.html Now lets see how we can do the reverse.The scenario is as follows. There’s a table…
Importing DBF files to SQLServer Table using SSIS
Recently we had the requirement of importing data from multiple dbf files to SQL Server database. This post explains the step by step procedure of how this can be achieved using SSIS and also discusses the resolution to an issue…
T-SQL to DAX: Simulating PERCENTILE_CONT analytic function
PERCENTILE_CONT is used for calculating a percentile based on a continuous distribution of the column value. From ORACLE SQL documentation:The result of PERCENTILE_CONT is computed by linear interpolation between values after ordering them. Using the percentilevalue (P) and the number of rows…
T-SQL to DAX: Simulating CUME_DIST analytic function
CUME_DIST() analytical function was introduced in SQL 2012 for calculating the cumulative distribution of a value in a group of values.Its calculated as number of rows with value equal to or less than current value divided by total rows for…