ssis - Http Request Timeout using Cozyroc for connecting to Salesforce -
i have ssis package transferring data sql server salesforce , back, using cozyroc ssis+ library. package composed of multiple data flow tasks. seems fail due http connection timeout @ 1 particular executable in 1 of tasks. executable, basically, tries fetch data account object in salesforce. there other executables, earlier in package connect , download data salesforce fine, including account object. stack trace follows:
event name: onerror message: system.net.webexception: operation has timed out @ system.net.httpwebrequest.getrequeststream(transportcontext& context) @ system.net.httpwebrequest.getrequeststream() @ cozyroc.sqlserver.ssis.gzipwebrequest.getrequeststream() @ system.web.services.protocols.soaphttpclientprotocol.invoke(string methodname, object[] parameters) @ cozyroc.sforce.service.sforceservice.query(string querystring) @ cozyroc.sqlserver.ssis.sforcesource.preexecute() @ microsoft.sqlserver.dts.pipeline.managedcomponenthost.hostpreexecute(idtsmanagedcomponentwrapper100 wrapper) operator: source name: dailyjob source id: {63f0db1d-84fa-40e6-bdf4-3c375f839630} execution id: {c92ae13a-a0ee-467f-925b-0520654e3e45} start time: end time: data code: -1073450910
any appreciated.
thanks
try increasing timeout parameter in salesforce connection manager.
Comments
Post a Comment