Learned something new, but the reference could be more complete.

The MSDN article never states that the ROWLOCK hint can/will be ignored after the threshold has been passed.

I don't think so.

So every service is installed on localhost, and you're trying to connect to SSAS with Excel, also on your localhost?

That's odd. If you installed everything local, Excel should find SSAS just fine.

Can you log into SSAS using Management Studio?

ps: to use TCP to connect to SSAS, you just replace...

Back on-topic:

http://www.sqlservercentral.com/Forums/Topic1268199-391-1.aspx

Or am I working with SQL too long to realize this is an ordinary beginner's question? Am I asking too much?

This query selects all columns and the rows from the table xyz who satisfy the condition that the row was updated before the year 2012. If the row was never...

Gianluca Sartori (3/16/2012)

---

Oracle owns MySQL, but there's a community edition of the product that can be downloaded and used at no charge.

Oracle offers Standard/Enterprise editions and maintains additional tools/features on...

How's the relation between...

You normally don't need SQL Browser to connect to SSAS.

Probably the default port is changed, so that's why you cannot connect to SSAS. Try giving the IP address and the...

Where are you going to "give a date"?

Do you mean instead of 2010?

That will not work, as YEAR(myColumn) returns an integer, so it needs another integer to be compared with,...

My guess is that you have selected the Table or View option in the OLE DB Destination.

Change this to Table or View - Fast Load.

And be amazed 😀

The flat file connection manager for the error file, what is it's row delimiter?

What are you using to view the error file?

Casper101 (3/15/2012)

---

We have 4 production servers still running sql 2000. I finally convinced business that it is time to upgrade to 2008. But after reviewing the licensing fees they are...

Except for some very very minor additions for ADO.NET, SSIS 2008 and SSIS 2008R2 are exactly the same. Packages developed for 2008R2 will work on 2008.

Easy point for me on Friday. :w00t:

However, any answer containing the word "unlimited" is wrong by default.

ps: do not test this in production! 😀

*gasp*

It can be no coincidence that this topic is full of elite DBA's!

(for some strange reason I first read evil...