Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

After getting an RPC error when trying to login to my server via either consol or Terminal services, then rebooting, I can no longer connect to SSIS

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Connect to SSIS Service on machine "BG-22SQL" failed:

The service did not respond to the start or control request in a timely fashion.

.

Connect to SSIS Service on machine "BG-22SQL" failed:

The service did not respond to the start or control request in a timely fashion.

.

Can you start the SSIS service on this machine (try starting it via the Service Control Manager)?

If the service fails to start, please see if this KB article applies to your configuration:
http://support.microsoft.com/kb/918644sql

Failed to retrieve data for this request.

I am trying to load data into a SQL Server table through a web page. I am getting error like this:

Error: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

I am doing the same for other tables in the same db its working fine. but its working for one table alone. The table name is like this (DTD_PUMA_DeliveryPerformance)

Is it cos of table name?

I tried with import/export wizard also its working fine but still its not working for web page.

I don t think its cos of network or OS!! Its with table or some connection property.

Pls help me in solving this.

There is nothing wrong with the tablename.

Have you checked the connection string and compared it to the one on pages that are successful?

|||

Thanks for the reply.

Identified the problem, its cos of the excel sheet.

There is a row in the excel sheet with the description ("Get Keys"), when i removed tht row its working

So i need to know how to exclude the first row from the excel sheet while selecting (select * from [Sheet1$]).

fail connect to intergrate services

Message:

Cannot connect to server
additional information
- failed to retrieve data for this request.(microsoft.sqlserver.smoenum)
- connect to SSIS service on machine "server" failed:
error loading type library/dll
- connect to SSIS service on machine 'server' failed :
error loading type library/dll

any idea?

soonyu

Have you started the SSIS Service?

-Jamie

|||

if you talking about services->SQL Server Integration Services
then confirm service already start.

an still the same Problem
-soonyu

|||using sql2005 64bit
solve with install service pack 1

--soonyu

Extremely simple query (I hope) but I can't solve it

Hi, I'm new in MDX and I have a request that I think is extremely simple, but I can't make it.

I have a dimension with a hierarchy, like this

[Dim1]

[Hier_Dim1]

All

Level1

SLevel12

SLevel13

Level 2

SLevel21

SSlevel211

SSLevel212

etc.

I want the values of a measure [Measures].[Total] on the childrens of SLevel21, I write this MDX

SELECT NON EMPTY { [Measures].[Total] } ON COLUMNS

, NON EMPTY { [Dim1].[Hier_Dim1].&[SLevel21].Children} ON ROWS

FROM [My Cube]

Result Set I expect is

SSLevel211 Total1

SSLevel212 Total2

But I have this

Level1 SLevel2 SSLevel211 Total1

Level1 SLevel2 SSLevel212 Total2

I want to use result set on a report that receive as a parameter the member of hierarchy selected, so the number of columns returned should't depend on parameter selected.

Regards

Julio Diaz

What you are seeing here is a "flattened" cellset. I don't know of anyway of suppressing these extra columns that are generated when the results are "flattened" (converted from a multi-dimensional to a 2 dimensional result), but what you can do is to create a calculated member which will give you a consistant column name that you can use in your report. So in the example below you would use the [Dim1_MbrName] column in your report to get the names of the children of the selected member.

WITH MEMBER [Measures].[Dim1_MbrName] AS [Dim1].[Hier_Dim1].CurrentMember.Name

SELECT NON EMPTY { [Measures].[Dim1_MbrName],[Measures].[Total] } ON COLUMNS

, NON EMPTY { [Dim1].[Hier_Dim1].&[SLevel21].Children} ON ROWS

FROM [My Cube]

|||

Thanks Darren, It works good!

Now I′m trying to pass [Dim1].[Hier_Dim1].&[SLevel21] as a parameter, but it is another topics my question was answered :)

Regards

Julio Diaz