dave.molyneaux (9/17/2010)

---

I'm having problems traversing subfolders. I have a main folder with nothing in it and then several subfolders with up to 2 files each. There are two...

cmbrooks08 (9/17/2010)

---

This MDX query runs fine-

SELECT

KPIValue("XXX") ON COLUMNS,

(

[Facility Attributes].[Latitude].Children,

[Facility Attributes].[Longitude].Children,

[Facility Attributes].[Building Name].Children

) ON ROWS

FROM

[Cube]

The issue we have is that some of the Lat and Longs are null,...

dpatelia (9/16/2010)

---

Hi

I have created one SSIS package which will load files from one perticular folder into database. as I have no. of files and all the file structure is...

Please follow here

Stamey (9/17/2010)

---

My package uses checkpoints and goes like this:

Run TSQL (These steps may be TSQL or procedure)

For Each Container 1

Run TSQL

Load Data

End container 1

Run TSQL

For Each...

All said fine Arun,

But to some extent I believe that report should not have pop up's.

The users have to be...

randy.jaye (9/16/2010)

---

I have the following MDX calculation in my SSAS cube that returns Prior YTD Sales based on the current date.

Sum(YTD(ParallelPeriod([Calendar].[Year-Quarter-Month-Week-Day].[Year],1,[Calendar].[Year-Quarter-Month-Week-Day].CurrentMember)),[Measures].[Net Sales])

This will return the YTD sales for prior year,...

coffeewithmax (9/16/2010)

---

thanks for response

IN PACKAGE

i have a parent package in for loop i am calling a child package .

in the child package - data flow i am loading a...

pjrpjr7 (6/16/2010)

---

I have a report which groups the data based on country. For example, the columns are country name, product name and sales. I grouped the data in tablix based...

😉

I missed here

Thanks for the quick revision...:-):-):-)

coffeewithmax (9/16/2010)

---

hello

In one of child package while loading data from excel sheet to destination source, i am able load the header part of the excel but not data in...

Shailesh,

Please follow

Drive:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager\Styles

Though you can only make few changes :-):-):-)

Why do you want to "Sort" dimension members??

A script task and Regular expression :rolleyes::hehe::cool: