Quering AS2005 Cube to generate CSV or Excel in SISS 2005

can any one sugest Quering AS2005 Cube to generate CSV or Excel in SISS 2005

i have a mdx query that runs fine in SQLserver 2005 but when use OLEDN source in SSIS and connect to Flatfile source i am getting OLEDB exception is there any work arround i have SQL Server 2005 SP2 on Windows 2003

Any help is really appreciated

thanks in advance

The actual error message would be helpful.

Are you using the OLEDB provider for OLAP to try to connect to a flat file? That won't work.

|||

thank you

i use OLEDB source and under the connection i choose the AS 9.0

can please suggest the ways to quering a Cube using MDX in SISS

|||

You might take a look at this post:

http://sqljunkies.com/WebLog/hitachiconsulting/archive/2007/07/04/42805.aspx

It explains how to use the DataReader source to get the data from the cube.

Quering AS2005 Cube to generate CSV or Excel in SISS 2005

can any one sugest Quering AS2005 Cube to generate CSV or Excel in SISS 2005

i have a mdx query that runs fine in SQLserver 2005 but when use OLEDN source in SSIS and connect to Flatfile source i am getting OLEDB exception is there any work arround i have SQL Server 2005 SP2 on Windows 2003

Any help is really appreciated

thanks in advance

The actual error message would be helpful.

Are you using the OLEDB provider for OLAP to try to connect to a flat file? That won't work.

|||

thank you

i use OLEDB source and under the connection i choose the AS 9.0

can please suggest the ways to quering a Cube using MDX in SISS

|||

You might take a look at this post:

http://sqljunkies.com/WebLog/hitachiconsulting/archive/2007/07/04/42805.aspx

It explains how to use the DataReader source to get the data from the cube.

sql

Qualifier in URL Access not working

Hi,

When I export to CSV using URL Access, it doesn't include the default Qualifier ("). Even when I tried to use Qualifier=" or some other value, it doesn't include the qualifier in the output CSV file.

Any idea?

Thanks in advance.

Mouli
What version of Reporting Services are you using?

-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.|||

You probably need to add rc: before Qualifier to make it work.

Your URL would look something like:

/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier" href="http://links.10026.com/?link=http:///reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier">http://<server>/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier="

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

I'm trying to get the "-text qualifier to work as well in CSV exports, but without any luck. Are there any other conditions which should be met for text columns to get exported within quotes?

Regards, Jeroen

|||

What does the URL you're specifying look like?

-Lukasz

Qualifier in URL Access not working

Hi,

When I export to CSV using URL Access, it doesn't include the default Qualifier ("). Even when I tried to use Qualifier=" or some other value, it doesn't include the qualifier in the output CSV file.

Any idea?

Thanks in advance.

Mouli
What version of Reporting Services are you using?

-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.|||

You probably need to add rc: before Qualifier to make it work.

Your URL would look something like:

/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier" href="http://links.10026.com/?link=http:///reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier">http://<server>/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier="

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

I'm trying to get the "-text qualifier to work as well in CSV exports, but without any luck. Are there any other conditions which should be met for text columns to get exported within quotes?

Regards, Jeroen

|||

What does the URL you're specifying look like?

-Lukasz

Qualifier in URL Access not working

Hi,

When I export to CSV using URL Access, it doesn't include the default Qualifier ("). Even when I tried to use Qualifier=" or some other value, it doesn't include the qualifier in the output CSV file.

Any idea?

Thanks in advance.

Mouli
What version of Reporting Services are you using?

-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.|||

You probably need to add rc: before Qualifier to make it work.

Your URL would look something like:

/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier" href="http://links.10026.com/?link=http:///reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier">http://<server>/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier="

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

I'm trying to get the "-text qualifier to work as well in CSV exports, but without any luck. Are there any other conditions which should be met for text columns to get exported within quotes?

Regards, Jeroen

|||

What does the URL you're specifying look like?

-Lukasz

Qualifier in URL Access not working

Hi,

When I export to CSV using URL Access, it doesn't include the default Qualifier ("). Even when I tried to use Qualifier=" or some other value, it doesn't include the qualifier in the output CSV file.

Any idea?

Thanks in advance.

Mouli
What version of Reporting Services are you using?

-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.|||

You probably need to add rc: before Qualifier to make it work.

Your URL would look something like:

/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier" href="http://links.10026.com/?link=http:///reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier">http://<server>/reportserver/?/itempath&rs:Command=render&rs:Format=CSV&rc:Qualifier="

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

I'm trying to get the "-text qualifier to work as well in CSV exports, but without any luck. Are there any other conditions which should be met for text columns to get exported within quotes?

Regards, Jeroen

|||

What does the URL you're specifying look like?

-Lukasz