Hello,
I have a WebService and a task in there.
I use a SSIS Package to execute this WebService, also this WebService will execute my task.
I use SQL Server Agent to set daily time to execute a job and step of this job this SSIS Package above.
SQL Server Agent ---> Set daily time ---> Execute SSIS Package ----> Call WebService ----> Do my task
I set security for WebServices is:
<location path="MyPrivateServices.asmx">
<system.web>
<authorization>
<deny users="*"/>
</authorization>
</system.web>
</location>
and this config also prevent I execute SSIS package to call WebService, how can I allow execute my webservice from SSIS Package and prevent other ways.
Please gives me some advices, thank you.
...
Go to the complete details ...