I've attended the courses intended for both the 70-466 and 70-467 examinations, and after passing 70-466 I can confirm that this course helps...

Ok I've managed to resolve the issue. Unless anyone else has other methods this is the only way I could get multi value parameters to work on an OLE DB...

Thanks for replying. Unfortunately it does not work. I keep getting the error...

I guess everybody has their own expectations and one, for me at least, is that I would have expected much more of a concise offering of advice from a 'Microsoft...

spaghettidba (10/17/2014)

---

dapoole (10/17/2014)

---

Koen Verbeeck (10/17/2014)

---

If you find that any advice given to you was below your standards of quality, the people that gave you the advice...

Koen Verbeeck (10/17/2014)

---

If you find that any advice given to you was below your standards of quality, the people that gave you the advice will gladly...

Finally some helpful ideas. I'll download and give this a shot. Thanks guys.

The company refuse to pay and have not paid for the support and development of one of their systems for over 10 years. The database is un-upgradeable from SS2000 because...

I've worked out a solution. Use 'net use' with xp_cmdshell.

DECLARE @CmdString1 VARCHAR(2000)

DECLARE @CmdString2 VARCHAR(2000)

SET @CmdString1 = 'net use Z: \\10.10.10.5\f$ /persistent:yes /user:domain\userid password'

SET @CmdString2 = 'copy \\10.10.10.5\f$\test.nightly H:\MSSQL\Backup\test.nightly'

EXEC master.dbo.xp_cmdshell @CmdString1

EXEC...

PB_BI (9/22/2014)

---

Out of the box, SSAS will always put a Distinct Count in it's own measure group. There are, however, other methods that you can try which may or may...

Knight's 24 hour SSIS:

http://books.google.co.uk/books/about/Knight_s_Microsoft_SQL_Server_2012_Integ.html?id=jOM7XE5pbPoC&redir_esc=y

Basically this book and the training kit greatly helped me. It was an interesting exam for me.

Best of luck.

Passed 70-463 yesterday. Enjoyed the exam much more than 70-461. Going to have a break then focus on 70-462 in a few months.

70-463 is all about Data Warehousing and is quite enjoyable to learn. 70-462 is focussed on Sql Server administration. After I passed 70-461 I went on to 463, which I...

Passed 70-463 yesterday. Went with the offical training kit and Knight's 24 hour trainer.

I'd future-proof your knowledge and go with the most up-to-date exams; 2012.

Also I wouldn't work for a bank in IT. I know of a lot of outsourcing being planned and...