Best SSIS scripting tome?

Is The Rational Guide to Scripting SQL Server 2005 Integration Services Beta Preview by Donald Farmer the best way to learn how to use scripting in SSIS as of late 2006? I'm not a .NET developer, although I come from a Java and C++ background.

I already own Professional SQL Server 2005 Integration Server, but that one doesn't cover scripting so much.

Thanks in advance.

Donald is a frequent poster on this site. However, this question might be hard for him (and me) to answer because of conflict of interest issues.

I work with Donald and I can assure you that he is quite knowledgeable in the uses, misuses and intricacies of SSIS.

As one of our primary points of contact with customers he also owns a wealth of experience in typical and interesting uses for scripting.

I hope this helps inform your decision.

|||

I've read that book.. It gives you a nice understanding of the ScriptTask and ScriptComponent ( http://msdn2.microsoft.com/fr-fr/library/ms345171.aspx ) and gives you some tips and advices throughout the book. It covers input/ output variables and how to access them in the ScriptTask etc... The book has some practical realworld scenarios at the end.

However the real power of SSIS is hidden in the CustomComponent, but that's not even mentioned - well atleast imho (it's a lot easier to debug CustomComponents contra ScriptComponent which are nearly impossible)

Overall I was very happy with the chapters, the writing is clear and easy to understand. And if you understand Java it should be easy to get started with.

Best material on MDX scripts?

Hi,

I am looking for some good and elaborate material on MDX scripts. I have read "MDX Scripting Fundamentals" at MSDN, but this material seems kind of basic:

http://msdn2.microsoft.com/en-us/library/ms145973(en-US,SQL.90).aspx

Does anyone have a good reference?

/Michael

There aren't any yet, I'm afraid. I've just finished writing the chapter on MDX Scripting for the second edition of 'MDX Solutions' (see http://www.amazon.com/exec/obidos/tg/detail/-/0471748080/qid=1130331934/sr=8-4/ref=pd_bbs_4/102-8919619-9916967?v=glance&s=books&n=507846 ) and had to go direct to the dev team to ask my questions.

There are some examples of more complex MDX Scripts on Mosha's blog (http://www.sqljunkies.com/WebLog/mosha/default.aspx), Richard Tkachuk's site (http://www.sqlserveranalysisservices.com although it seems to be down at the time of writing) and my blog (http://spaces.msn.com/members/cwebbbi/).

HTH

|||Thanks Chris

Seems odd that MS has not produced more elaborate documentation on these new features. Looking forward to the book you are co-authoring, though... Also good to see that the author of the previous "MDX Solutions" is in on it.