I am consuming a web service in a WCF Client app and subsequently update my DB with the latest updates. The WCF is configured using basicHttpBinding, securityMode of TransportCredentialOnly, and clientCredentialType of Windows. My timeouts (Close,
Open, Receive, Send) are all set to 10 minutes. I am using a Sql Server Agent Proxy with the correct Domain account (actually the same account that is logged into the server itself) given the SSIS Package Execution subsystem and said Proxy
is being used for the 'Run as' in the package Step. The account is a local Administrator AND a sysadmin.
I want to host this WCF app as a Windows service or a scheduled task. I want to know if I can do this and if so, how to accomplish? This service handles minimum of 100 records to max of 100,000 records. The task needs to be automated and scheduled. Appreciate
View Complete Post