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

Popular posts from this blog

windows - Single EXE to Install Python Standalone Executable for Easy Distribution -

c# - Access objects in UserControl from MainWindow in WPF -

javascript - How to name a jQuery function to make a browser's back button work? -