Can you run your generated SQL in SSMS? It looks like there is a problem with the SQL from the error.

HTH,

Rob

What about the NON EMPTY keyword? Did you use the NONEMPTY function or the NON EMPTY keyword?

http://thatmsftbiguy.com/nonemptymdx/

HTH,

Rob

Have you tried the NONEMPTY() function?

http://msdn.microsoft.com/en-US/library/ms145988(v=sql.105).aspx

HTH,

Rob

avishain (1/21/2013)

---

im developing an ssis package.

while im in the sql server , there is a field that contains a text string , for example:

December 13, 2008

and so on...

i want to...

Chris Clarke-296861 (1/19/2013)

---

We've a web application that's using the Reporting Services viewer and an .rdlc file to produce a report of an invoice.

It's running on SQL Server 2008R2 database and...

Sounds like a permissions issue; can you work with your server admins to get the correct permissions assigned to that proxy account?

Rob

sumit.joshij (1/17/2013)

---

Is it possible or any other way to assign the Derived column expression value in a column.

for eg:

@[User::newcol]= FILE_PATH + "/" + FILE_NAME.

Please see the attachment for the same...

Yes, I believe you can only sequentially process a cube with SSAS Standard edition.

Rob

sathiyan00 (1/7/2013)

---

Hi friends,

I'm new to mdx . anyone please explain the flow of this or any simple mdx expression.so that i can get...

pulluri1226 (1/3/2013)

---

I have a flat file with comma separated columns (16 columns per record/line)

but for few records, there are only 4-5 columns, in that case data flow is inserting...

engg.pankaj (1/3/2013)

---

Thanks for the reply again.

I know how to write SUM() and group by queries in T-SQL however, I want to know how to write this query and show the...

No, you wouldn't need to...

Rather than trying to do this in an expression, change your datasource and do it in T-SQL. Much easier.

Rob

Don't ask the same question in multiple forums as it just fragments the conversation. That said, you've had no responses yet. Have you loooked at the error logs...

varshachyk (12/27/2012)

---

Hi,

We have a SQL server standard edition in our project. for performance tuning, one of the client SME has recommenced to configure parallel processing. when we try to configure...