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