Hi Grant,

Understood, I was hoping that would not apply for something relatively basic, and also I had not seen anyone else encounter something similar in my initial searches. ...

Grant Fritchey (6/9/2014)

---

You are posting in a SQL Server 2008 forum. Since you're using Sybase, you're more likely to get specific assistance by posting the question in a forum dedicated...

wcharlton1 (6/8/2014)

---

Hello,

I am new to SQL and scripts in general so please bear with me. There are 3 tables involved: CLIENTS, WORKTIME and BILLING. Each table contains 5 fields...

rockon_dba (8/29/2011)

---

I have a package on 2008r2 and job on 2005 pointing to the package on 2008r2. When i run the job i get the following message 'Description: While trying...

Dead on!

Very perceptive, thanks.

:hehe:

As far as I know, this is the full path.

I have it in this format

\\server\folder$\folder\folder\...\file.xlsx

the second folder in appears to be a normal folder, with $ at the end of...

well I think it's safe to say that the creation of the network share was causing the issue. It works consistently when created locally.

But what i cannot understand is...

Thanks,

I tried researching that, and it seems that is only for data source connections that support multiple connections. Excel definitely does not, and the property is likely ignored.

First...

are multiple people running the report with the same parameters?

or in your testing are you running it once when it takes 30 seconds, and then the same parameters takes...

bump?

I know there are a lot of bright minds on here, somebody surely has come across this before?

I am going to try to make / populate the xlsx file...

forget the format of the xls, sort the data, and look for a nonnumeric.

I am getting this error now, almost to the T as the OP. But i figured out a work around.

What was not communicated/grasped above, was that the data viewer...