SSIS vs SSRS

Link. September 16, 2007. Comments [1]. Posted in:

Ayende has been very vocal about his opinion of SSIS (SQL Server Integration Services) in the past, and, to be fair, he has some good points and indeed working with SSIS can be a pain in the neck many times. However, I've discovered that I despise SQL Server Reporting Services (SSRS) far more than I could ever  SSIS.

Working with Reporting Services is about as much fun as sticking needles under your fingernails. It insists on changing stuff on it's own, like switching report parameters to multi-value after you tell it you want them single-values, reverting a dataset parameter to some weird incorrect value you once typed in (no matter how many times you change it), or just throwing weird errors in your face. And don't even get me started on the joke that is the MDX query designer.

FWIW, I think most of my issues (if not all of them) with SSRS are directly related to the design-time support for authoring reports; I don't think I have many problems with the actual runtime behavior of it (for now).



Sunday, September 16, 2007 5:24:38 PM (SA Pacific Standard Time, UTC-05:00)
I absolutely agree. I work with every one of the pillars of SQL Server 2005, and by far, SSRS is the buggiest. And like you, most, if not all, of the issues I've come across are related to the design-time experience. Support for SSAS reports is "workable" at best.
Todd
Comments are closed.

Syndicate

About

Tomas Restrepo is a software developer located in Colombia, South America. His interests include .NET, Connected Systems, PowerShell and lately dynamic programming languages. More...

tomasrestrepo @ twitter My Flickr photostream My saved links on delicious My Technorati Profile

email: tomas@winterdom.com
msn: tomasr@passport.com

View my profile on LinkedIn

MVP logo

Ads


Categories

Statistics

Total Posts: 1050
This Year: 1
This Month: 1
This Week: 0
Comments: 825

Archive

Other

Copyright © 2002-2008, Tomas Restrepo.

Powered by: newtelligence dasBlog 2.2.8279.16125

Sign In