BenWard (6/13/2014)

---

Thanks Koen,

Sleep mode is disabled and I've even told the network adapter never to shut off now.

It would appear it's doing it even if the SSIS application looses focus...

If you lock your computer, it might go to sleep after a while.

You can check the power management of the computer to see if the network adapter is disabled when...

Open up visual studio and go to the cube. If the dimension...

In DQS you can maintain a knowledge base. For example, you can store that NY must be automatically converted to New York. It can also correct New Yokr to New...

You need to install the...

OK, did you install SSAS on the computer?

If yes, did you install it under the default instance, or did you use a named instance?

Seems like a duplicate thread of this one:

http://www.sqlservercentral.com/Forums/Topic1580326-1633-1.aspx

hoseam (6/13/2014)

---

Hi Steve

I don't understand what do you mean by that. Service being installed as an instance or the default instance.

I installed BIDS 2008 R2. anything further than that,...

Copy paste the code out of the UDF into your code. Modify it to your need.

Cry...

An easy question on Friday the 13th, who knew 🙂

One extra advantage of the integer date key I forgot:

it is very easy...

Sean Lange (6/12/2014)

---

below86 (6/12/2014)

---

Sean Lange (6/12/2014)

---

below86 (6/12/2014)

---

I'm just looking at our 'new' datawarehouse design, a former DBA helped start. All the table names start with 'tbl'. :w00t: This...

And views start with vw_? And then suddenly,...

sql_novice_2007 (6/12/2014)

---

I don't have the package. It was a very old one and I recently joined in the company and the previous DBA might have had it but now I...

Did you consider hiring a consultant? Remember the people on these forums are...