I'm migrating servers (going from SQL Server 2005 to 2008). I have a job that accesses an external XML file and then imports the data into SQL Server 2005. I've migrated over to a new server but can't get the job to execute. I've tracked it down to something related to sp_OAMethod I believe. Not sure if it's a permission issue or an installation setup / version issue or something else.
sp_OACreate and sp_OASetProperty seem to execute without error... but then this seems to return the error:
exec @err = sp_OAMethod @objHTTP, 'load', @resp_int out, @addr
if ( @err <> 0 ) begin
exec sp_OAGetErrorInfo @objHTTP, @err_src out, @err_desc out
raiserror( 'dbo.xml_handle_get> Error calling COM component method 0x%x, %s, %s', 16, 1, @err, @err_src, @err_desc ) with seterror
Thanks in advance!