One thing to keep in mind when you use this impersonation mode is password changes. Most windows domain admins have password policies in place requiring users to change passwords...

Mark F-428640 (10/28/2010)

---

Hi John while waiting for your response I found a way to deploy I simply provided my windows login details in the impersonation tab and that seem to...

I use a domain account. This can be a special account that you set up just to run your cubes, or you can use your domain account to run...

Working with the data source in BIDS uses your user credentials to access the objects from your data source. When you go to deploy the cube (and when the...

Right, OP needs to keep an eye on it. My point was that just because he/she is not shrinking the file does not mean that more disk space is...

I would say just...

SQLBill (9/2/2010)

---

Great manager.

Great director.

Work from home three days a week.

25 paid days of time off.

Work laptop to use when working from home.

On call for one week once every two months.

Guaranteed...

Thanks Gus, your correct.

Chrissy321, You mentioned that you can't put the flag at the parent level because application/security reasons. Rarely have I seen where outside factors like app security...

Am I missing something Gus?

Here's one option......

SELECT c.ChildID,

c.ParentID,

c2.Flag

FROMChild c

LEFT JOIN (

SELECT ParentID,

CASE WHEN SUM(CASE WHEN Flag = 'Y' THEN 1 ELSE 0 END) >= 1 THEN 'Y' ELSE 'N' END as...

I would eliminate the step to shrink the logs. You'd be better off letting the logs grow to their optimal size. Shrinking the log reclaims the space, but...

Big League Chew

Yes, more info would help a ton. ...

pmscorca (10/25/2010)

---

Hi, thanks.

It is occured to have data with an error (f.e. conversion error, arithmetic overflow, ...). The goal isn't to insert the right data but to find which row...

Data Flow source adapters do allow for SP execution. Does attempting this give you an error?