DECLARE @Route Geography

BEGIN TRY
        SELECT @Route = geography::STGeomFromText('LINESTRING(' + @i_Route + ')', 4269);
END TRY
BEGIN CATCH
            DECLARE @error Int, @message NVarChar(4000), @xstate Int;
            SELECT @error = ERROR_NUMBER(), @message = ERROR_MESSAGE(), @xstate = XACT_STATE();

            PRINT CAST(@error AS NVarChar(10)) + ' - ' + @message
END CATCH