rals (4/17/2013)
Batch process means SSIS package ?If you are using SSIS, recently I came across a situation that extracting data using a view from SSIS slower but running the same view in SSMS is faster.
"SSIS - views as data source - very poor performance or SSIS hangs".
Please refer the below links.
Thanks, the night process actually use a web service not SSIS.