Jorg Klein's Microsoft Business Intelligence Blog [Macaw] - All Comments

Business Intelligence Blog » Blog Archiv » SSIS semi-blocking transformation f??r Distinct

Thu, 10 Jul 2008 21:27:51 GMT

Pingback from Business Intelligence Blog » Blog Archiv » SSIS semi-blocking transformation f??r Distinct

re: SSIS - Convert various String date formats to DateTime with the Script Task

hunki@hotmail.com — Thu, 10 Jul 2008 21:04:14 GMT

Thanks. Exactly what I was looking for.

re: MCTS - I passed the 70-445 exam!

ismailc — Thu, 22 May 2008 06:39:51 GMT

Thank You very much - i will purchase the kit & hopefully in months to come - pass the exam :)

re: MCTS - I passed the 70-445 exam!

jorg — Wed, 21 May 2008 14:49:43 GMT

Ismailc,

Thats the correct kit!

You only have to buy the kit. You will receive a DVD with the book, on this DVD are prep exams so you don't need to buy other prep test software.

re: MCTS - I passed the 70-445 exam!

ismailc — Wed, 21 May 2008 14:29:41 GMT

Hi, Thank You for the advice.

Is this the coorect kit: search.barnesandnoble.com/.../isbnInquiry.asp

I read that the kit enough won't make it but i don't have the finance to buy both the kit & one of the two prep test (Pass4Sure, Selftest)

Please Advise!

re: MCTS - I passed the 70-445 exam!

jorg — Wed, 21 May 2008 07:03:11 GMT

Hi Ismail,

In spite of you're doing all the courses, I still want to recommend you the training kit. Just following the courses is not enough.

Buying the TK also gives you prep exams, you'll get them for free with the book.

Jorg

re: MCTS - I passed the 70-445 exam!

ismailc — Fri, 09 May 2008 06:35:23 GMT

Hi, I need help please!

I'm going to write the exam in the next month.

Currently working with SSIS & SSRS but no experience in SSAS at all.

Going on the course next week: 2791,2792,2793.

I would like to know would the course material not be sufficient for me to pass (manuals only)?

Or must i still get the training kit: MCTS Self-Paced Training Kit (Exam 70-445)?

I would also like to do some prep exams:

1. I tried searching for it on the recommended site but can't locate it on www.examinside.com

2. I downloaded the demo of the foloowing but they are all expensive:

Pass4sure

SelfTest

Transcender

I don't know what to do, i really like what i'm doing so i must get certfied - the problem is i don't know which path to go & don't have the money to purchase the prep exams, which prep exam should i get?

Please, Please Help

Regards, Ismail (SA)

MCTS - I passed the 70-445 exam! - Jorg Klein's Microsoft Business Intelligence Blog [Macaw]

Mon, 21 Apr 2008 07:08:44 GMT

Pingback from MCTS - I passed the 70-445 exam! - Jorg Klein's Microsoft Business Intelligence Blog [Macaw]

MCITP - I passed the 70-446 “PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005” exam!

Jorg Klein's Microsoft Business Intelligence Blog [Macaw] — Fri, 28 Mar 2008 14:00:46 GMT

Today I passed the Microsoft IT Professional(MCITP) 70-446 “ PRO: Designing a Business Intelligence Infrastructure

MCITP - I passed the 70-446 “PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005” exam!

Jorg Klein's Microsoft Business Intelligence Blog [Macaw] — Fri, 28 Mar 2008 13:43:37 GMT

Today I passed the Microsoft IT Professional(MCITP) 70-446 “ PRO: Designing a Business Intelligence Infrastructure

re: SSIS – Lookup Transformation is case sensitive

Jack Corbett — Tue, 04 Mar 2008 18:36:42 GMT

I also ran into this problem and after reading this post and others I was able to solve my problem. I went to the advanced tab and Checked Enable Memeory Restriction and Modify SQL Statement. Mapped the parameter and I was fine. It may still be hitting the DB once per lookup, but at least the lookup is working. I had tried using Upper in both my Lookup Query and Source Query and I still encountered the problem. Another "solution" I first used in this situation was to use a Fuzzy Lookup with a min similarity of 1 and I got the matches I needed.

re: SSIS – Non-blocking, Semi-blocking and Fully-blocking components

jorg — Tue, 04 Mar 2008 11:05:26 GMT

Simon,

You are right, of course.

I thought it would be clear that my blog is about normal input / output and not about redirected output.

Thanks anyways for your post; it might be useful for those that are confused.

Jorg

re: SSIS – Non-blocking, Semi-blocking and Fully-blocking components

Simon — Fri, 29 Feb 2008 15:13:53 GMT

Synchronous components don't have to output all the rows it gets. You can use the redirect method to conditionally out rows to different outputs as the multicast and conditional split do.

re: MCTS - I passed the 70-445 exam!

jorg — Wed, 27 Feb 2008 21:14:14 GMT

Srinivas,

Its not necessary to take the 70-431 exam prior the 70-445 exam.

If you have no knowledge on SSIS, SSAS, SSRS I think it’s possible to pass the exam after ½ year. You should start working with the related tools and study the training kit.

When you gain high scores on the exam questions that you’ll find on the CD of the book, you should be ready to take and pass the exam.

Good luck!

Jorg

re: MCTS - I passed the 70-445 exam!

Srinivas — Mon, 25 Feb 2008 03:47:57 GMT

Hey Klein ,

I just started working as a Sr.BI systems specialist.(1month). I have good knowledge of the writing queries in SQL. I want to take the 445 exam and specialize in BI. But is it necessary to take the 70- 431 exam before this. I felt that I dint want to take 2 similar exams. Please share your views on this. Also after reading your posts, I am planing to buy just the kit and prepare from that. I have no prior experience nor knowledge of any of the topics you have mentioned as important or tough. So what in your mind is a good time frame to keep to prepare for the exam.

Thanks,

Srinivas