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