Marco Russo's blog posts of 2005

Page 4 of 36 blog posts
blog post –

SQL Task in SSIS with external file

SSIS has a feature I desperately wanted in DTS for years: you can use an external SQL file as a source SQL statement for the SQL Execute Task. Unfortunately this is not available for Data Flow Source component. I tried using variables to load the SQL  Read more

blog post –

Useful webcast on MDX

Thanks to Chris Webb I discovered this useful webcast about MDX tips & tricks (rightly named Common MDX mistakes & solutions). It’s available even the whole transcript, so you can read it instead to listen after midnight :-)  Read more

blog post –

Install Reporting Services SP2 Web Parts on SharePoint

I just installed the Reporting Services SP2 beta on my dev-test machine. I had to search into beta newsgroups how to install SharePoint Web Parts onto my SharePoint Services installation: to do that, you need to start a command like: stsadm.exe -o addwppack  Read more

blog post –

BI Portal for SharePoint

A new version of BI Portal Sample is available from Microsoft. It looks good, but I still haven’t tested it. Integrated with SharePoint and Reporting Services. Support of different localizations. It’s not the definitive solution, but may be useful.  Read more

blog post –

Don’t use quote inside comments with Analysis Services 2000

Yesterday I lost at least an hour (but only for a coincidence I haven’t lose more hours) because I came across a bug of Analysis Services 2000. If you put a single quote or a double quote inside a comment, the whole MDX expression is not considered. I  Read more