Here's another alternative:
If OBJECT_ID(N'tempdb..#TravelDistance', N'U') IS NOT NULL
    BEGIN
    DROP TABLE #TravelDistance;
    END;

CREATE TABLE #TravelDistance (
    StartPt varchar(200),
    EndPt varchar(200),
    Distance int
);

CREATE NONCLUSTERED INDEX...

Try using a column list instead of *.   It's a particularly good habit to get into.   You'll still need to turn IDENTITY INSERT ON for the new table, not for...

TTLBusiness.Value must be something other than an integer, and your 0 value might just need to be converted to it's datatype using the appropriate conversion function.   Try that and let...

I'm not sure that you really need to look at it from both points of view, as once you start matching properties to opportunities, the perspective doesn't seem to me...

Don't have any direct experience with that kind of error, but is it possible that SSRS is seeking more memory than is readily available?  In other words, is it possible...