Daniel.

Thanks for the answer.. I have tried using Calculated members but I am not getting the corrrect data returned..

Can you please help me in figuring this thing out..

[Code]

create member [service...

As you guys suggested...I took the solution file from the Production server and deployed my cube to the test server and when i run the cube in SSMS for SSAS...

In my connection manager i have the file name but if i try to look for those files that directory doesnt exist at all...

Since these packages were created by some...

The sqlSourceType is a fileConnection and the FileConnection is AllowedtoFailPrologueSql

and i cannot find that file from the server where the ssis package is located...

Bru Medishetty (11/6/2009)

---

It looks like the SSIS Package was create without using the DataFlow task, the entire Data transfer must have been implemented in the Execute SQL tasks only, for...

Bru Medishetty (11/6/2009)

---

When you opened the package (added the package in the Solution) did you get any errors about it? and one more question do you see other components of...

When I open My .dtsx file from the file system in Bids.. why dont I see the data flow task...

Am I missing something when i am downloading it?

Any help will...

Thanks for the answer...

so when i give add existing package should it be from the file system or can i connect directly to the integration services and grab that...

CirquedeSQLeil (11/6/2009)

---

is there any chance they are running this job even though it is disabled? Maybe some other job calls this job, or some code somewhere calls and executes...

Do you guys know anything about SSIS Package Release and what kinda information will be in there...

Cause when i logged into the integration services server and right clicked on the...

I see a job on Machine A but its not been enabled so i am guessing thats not the job they are using... but there is no where else i...

Should i look in Machine A or Machine B or you can call this job from a different server?

no these files were created by someone... so we dont have access to the source code or the .sln file... Is there any ways i can find out whats in...

Gsquared...

I exported the package from SSIS to the file system and saved the package in my "My documents" folder...

and then opened that file is BIDS.. but i dont see what...

stevefromOZ (10/29/2009)

---

To answer your last question, yes, you can see the query, either by running a sql trace, or even simpler, in the processing dialog window, if you expand the...