Publish an SSIS Package result set as a SQL View

From SQL server version 2012 onwards there is an in-built mechanism to publish SSIS package result set into SQL view

1.    Requires SSIS package to be designed with Data Streaming Destination.

This destination component needs to be separately downloaded in 2012 and 2014. From 2016, it is part of standard toolbox item.

2.    Running Data Feed Publish Wizard

    i)  Creates a linked server – SSISOLEDB.

    ii) Creates a SQL view in the specified database.

Below are the steps to publish an SSIS Package result set as a SQL View

SSRS 2016 Mobile reports

In this post, I have provided quick walk-through on Integration of Mobile reports with SSRS 2016 

Below are the pre-requisites to play with mobile reports, Inside Azure VM – Install below software’s:

1.       Microsoft Visual C++ 2012 Redistributable (x86) - 11.0.61030
2.       Microsoft SQL Server Mobile Report Publisher
3.       Microsoft® SQL Server® 2016 Report Builder
4.       Configured a Firewall for Report Server Access
5.       AdventureWorks Databases and Scripts for SQL Server 2016 CTP3

SQL Server access Previous / Next rows and first / last row from partitioned resultset

From SQL Server 2012, new built-in analytic functions are introduced, using that we can easily access subsequent/previous row in the same result set without the use of a self-join and first/last value in an ordered set of values.

In this post, let us see some examples for LEAD(), LAG(), FIRST_VALUE() and LAST_VALUE()