August 19, 2013 at 6:29 am
Hi Team,
I want to know, do we have any re-usable components(like Macros,etc) for SSIS/SSRS/SSAS? If yes, please let me know. I'm intersted to know its functionality. Thanks.
Cheers
Jim
August 19, 2013 at 12:26 pm
Do you mean a component that you can re-use across all 3 areas (SSIS/SSAS/SSRS) or do you mean components that you can re-use within an area?
There are ways to write re-usable user components in SSIS and there are report parts in SSRS that I think would meet your criteria within an area. I've never worked with SSAS so I can't speak to that.
If you mean components that can be re-used across all 3 areas, I can't think of anything that would work across all 3. With SSIS and SSRS you could develop a DLL or web-service that you could use in both.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 20, 2013 at 4:30 am
i think SQL 2012 introduced shared datasources in SSRS
Regards
Durai Nagarajan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply