SSIS vs Restful Webserviceq
<p>I have a Oracle DB and have been getting data from it to my SQL Server DB via SSIS packages. Essentially i refresh most of my tables data using SSIS every 5 mins.</p>

<p>I also have a RESTful web service running on my IIS web server which my UI consumes. </p>

<p>I am thinking of either integrating the SSIS into my RESTful web services or removing the SSIS and hitting the Oracle db directly from WS to enhance security and simplify the overall architecture of the system</p>

<p>Would i expect to see a large impact to the speed. Is this essentially a bad idea all together or is it the correct thing to do security wise?</p>