String truncation using sp_OAGetProperty under SQL Agent

I have a stored procedures that uses sp_OAMethod and sp_OAGetProperty to download a string from a website.

When I run the proc in query analyzer window, no problem.

When I run the proc under SQL Agent, if the string is longer than 4096, it automatically truncates down to 512.

Why is this and how can I fix it?

[911 byte] By [CarolynEvans] at [2007-12-22]