I can't help you out with pentaho as I don't use the product myself. Their support website is here, so they may be able to offer you more.
If there are any more SQL server based questions please come back and ask them.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx