Scheduled BIDS package, asynch webservice call fails to run
A developer created a BIDS package that calls a webservice asynchronously (on its own thread) via a script task. The whole package works fine when run manually but when scheduled the webservice call fails. I don't think it a permissions issue. I think that after the async call is spawned, the package completes, and the task loses its "identity" What are your ideas on this ? (Any potential soiutions earn extra dog bones.) Barkingdog PS. When I say the webservice call fails, we can see from logs that webservice invocation never "reaches" the actual web service. There is no record of the original call being requested.
July 15th, 2011 5:04pm

Did you schedule to run it under the SQL Server Agent (the Agent runs asynchronously)?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
July 15th, 2011 5:08pm

Arthur, Yes we did schedule the job under the SQL Server Agent. I was not aware that the Agent runs asynchronously but do you think that relates to our issue? If so, how should it be done? TIA, barkingdog
July 15th, 2011 11:45pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics