Five things SSIS should drop
Posted
by jamiet
on SQL Blog
See other posts from SQL Blog
or by jamiet
Published on Tue, 11 May 2010 16:22:00 GMT
Indexed on
2010/05/11
16:35 UTC
Read the original article
Hit count: 396
sql server integration se
|ssis
Data source connections
Seriously, does anyone use these? I know why they’re there. Someone sat in a meeting back in the early part of the last decade and said “Ooo, Reporting Services and Analysis Services have these things called Data Sources. If we used them in Integration Services then we’d have a really cool integration story.” Errr….no.
Web Service Task
Ditto. If you want to do anything useful against anything but the simplest of SOAP web services steer well clear of this peculiar SSIS addition
ActiveX Script Task
Another task that I suspect has never seen the light of day in a SSIS package. It was billed as a way of running upgraded DTS2000 ActiveX scripts in SSIS – sounds good except for one thing. Anytime one of those scripts would try to talk to the DTS object model (which they all do – otherwise what’s the point) then they will error out. This one has always been a real head scratcher.
Slow Changing Dimension wizard
I suspect I may get some push back on this one but I’m mentioning it anyway. Some people like the SCD wizard; I am not one of those people! Everything that the SCD component does can easily be reproduced using other components and from a performance point of view its much more beneficial to use those alternatives.
Multifile Connection Manager
Imagining buying a house that came with a set of keys that didn’t open any of the doors. Sounds ridiculous right? How about a SSIS Connection Manager that doesn’t get used by any of the tasks or components. Ah, that’ll be the Multifile Connection Manager then!
Comments are of course welcome. Diatribes are assumed :)
@Jamiet
© SQL Blog or respective owner