Home Forums SQL Server 2008 T-SQL (SS2K8) sp_OAGetProperty @obj, 'responseText', @response OUT cannot handle large output RE: sp_OAGetProperty @obj, 'responseText', @response OUT cannot handle large output

  • Thanks Lowell,

    That is the kind of code I was looking for and I am pretty certain that it will work! Also thanks for not restating the easy answer "drop sp_OA.." I mean if I've googled long enough to find this thread then obviously I know there are alternatives but like everything there are huge pros / cons to all approaches (SSIS, Executable, Services, SQLJob) and for our scenario this T-SQL approach was chosen as the best and so far is getting the job done.

    Have a nice weekend.