Wednesday, March 03, 2010
I'm reading: Search in SQL Server Integration Services ( SSIS ) Package - Limitation of BIDSTweet this !
SSIS is the technology I practice the most in my daily work, and it's one of the areas of microsoft business intelligence that I love working the most. Whenever I find limitations of a technology, I try to do two things for the same: First is devise an alternative way to overcome the same and Second is request the feature justifying the need for the same.
One such limitation in BIDS is search functionality in SSIS. A typical complex package can contain 80-100 transforms quite easily. Now consider that I want to search for components in this package, there is no functionality out of the box that can be used in BIDS to search for transforms or tasks that contain the text ( name property ) that one would want to search.
This is one functionality that I love the most in Microsoft Office Applications like Word and Excel. It's also equally true that Office apps cannot be compared to SSIS, but still search is one functionality that makes life more manageable for a developer, especially when one is dragging the mess received in legacy from another developer. At present if you use search, it would just search the xml of the package and show the xml line, but would not move the focus on the component or property that one is looking out.
I hope that Microsoft adds this functionality to future versions of BIDS or some community add-ins like BIDS Helper brings this functionality the BIDS.