Do you get the error when you preview the report in VS2010? Or is it when the user is running it from Reporting Services, which hopefully is a 64-bit installation?

If I'm not mistaken VS2010 is a 32-bit application, so there is a 4GB limit. Have you tried to filter the report to reduce the number of rows of data?

Have you set the compatibility level to...

RTaylor2208 (7/2/2015)

---

I agree with what your saying IF the OP was using a regular shared folder, but the question they have posted is using a UNC path to a folder...

RTaylor2208 (7/2/2015)

---

As they are using an administrative share (L$) this is largely irrelevant, as providing the account used to run the SQL server Agent job whether that be the...

Which account is running the job? SQL Server Agent account? If it's a domain account you need to assign permissions on the path/share/directory to that account.

If SQL Server Agent is...

What if you try to convert the float to a decimal first? Perhaps that will work for you.

SELECT CONVERT(varchar, CONVERT( decimal(10,3) , @a))

Add Style 128 and see if it works for you:

SELECT CONVERT( varchar , @a, 128)

Style 128 (along with 126 and 129) is included for legacy reasons and might...

AndrewSQLDBA (9/12/2013)

---

That is one reason that I never use that Directory. I always use a directory on different drives.

Like "SQL 2008 Databases\[DatabaseName]"

I have never liked that directory of Program...

Thanks. Very useful. I'm right in the middle of cleaning up old user accounts after migration to a...

Have you tried running the query in SSMS logged in as the same user running the job?

tommy.tooten (9/12/2013)

---

You can find all the improvements over here: http://technet.microsoft.com/en-us/library/ms131456.aspx%5B/quote%5D

Thank you.

+1

The SQL Server Agent Account needs permissions on the network share and the directory where the file is.

Has the job worked before? Has there been any changes in permissions?

Have you tried running the query in SSMS logged in as the same user running the job?