loveindia Posted March 24, 2014 Report Posted March 24, 2014 I hope there are many SQL BI students in this forum.. How many of you know that you can use an SSIS package as a data source in an SSRS report? There is a very less chance you will get to work with such kind of situation in your entire career. If you open BIDS and see for SSIS as a data source for pulling the data, you won't see anything... so read this article, I wrote on How to enable SSIS to be used as a Data Source for SSRS. If you have any questions let me know... http://sqlsaga.com/ssrs/how-to-enable-ssis-as-datasource-in-reporting-services/ Like SQLSAGA on Facebook and help us reach more individuals. If you like the articles, please feel free to comment about your thoughts. If you have a question in mind, leave a note on our Facebook fan page or fill out our contact form or leave a comment in any respective topic or use this thread to leave a message to me. All topics will be addressed. Good Luck guys... :) and thanks for visiting www.sqlsaga.com
bokuboy Posted March 24, 2014 Report Posted March 24, 2014 nak SQL nerpinchava... vurakane oddu le.. paisal istha.. INR's lo :(
loveindia Posted March 24, 2014 Author Report Posted March 24, 2014 How many of you know you can use SSIS packages as a datasource in SSRS man?? Please be honest... wanted to know..
loveindia Posted March 24, 2014 Author Report Posted March 24, 2014 nak SQL nerpinchava... vurakane oddu le.. paisal istha.. INR's lo :( asalu dabbulu adigaana ninnu eppudanna ey vishayam lo aina.. nee pilla... neeku shitmallu ey correct... next batch lo join avvu...
bokuboy Posted March 24, 2014 Report Posted March 24, 2014 asalu dabbulu adigaana ninnu eppudanna ey vishayam lo aina.. nee pilla... neeku shitmallu ey correct... next batch lo join avvu... intiki elthunna.... 45 mins tarvatha call chesthava.. intlo net broke ayindhi i can't text vellaka andhuke chepthunna....
loveindia Posted March 24, 2014 Author Report Posted March 24, 2014 intiki elthunna.... 45 mins tarvatha call chesthava.. intlo net broke ayindhi i can't text vellaka andhuke chepthunna.... sare intiki vellu straight ga... bus lo adhi kanipinchindi idi kanipinchindi ani poku... asaley paadu lokam... ninnu red light area lo ammestundi...
Vinuu Posted March 25, 2014 Report Posted March 25, 2014 Hi.. hi...next training batch epudu starting on SQL server?
loveindia Posted March 25, 2014 Author Report Posted March 25, 2014 hi...next training batch epudu starting on SQL server? nuvvu eppudu antey appudu... cheppu.. evadiki undedi aadiki untadi .. gaadidha guddu...
Darling999 Posted March 25, 2014 Report Posted March 25, 2014 bhayya oka Question: Where exactly this kind of scenario is used in SSRS, I understood that package can be added as DS but one can easily get that dataset from a SP or a simple query right? let know if I am not clear, also under realtime scenarios they wont allow you to add this extension. So konchem explain cheyyava ee situation its really interesting to add it...!!!
loveindia Posted March 25, 2014 Author Report Posted March 25, 2014 bhayya oka Question: Where exactly this kind of scenario is used in SSRS, I understood that package can be added as DS but one can easily get that dataset from a SP or a simple query right? let know if I am not clear, also under realtime scenarios they wont allow you to add this extension. So konchem explain cheyyava ee situation its really interesting to add it...!!! Good and Intelligent question cute boy pranav... so why do we go for SSIS as data source when we can write a query or use a stored procedure from SQL Server / use MDX query and get data from a cube... the answer is... always relational database and olap cube is not only ur database. May be you need to show data from an archived file where you need to do some manipulations (like may be fuzzy grouping, fuzzy lookup and many other transformations) and use after all those transformations... When you are dealing with 10 records, its good you do it the sql server way... But imagine if you have some good number of records to group in the report and all, you need a lot of time to stage it and then query it.. so to avoid such scenarios ppl use it. Most of the times , yes we go with query / procedure... But some companies with constant real time data do go for this kind of approach... Yes it is not very well appreciated because the first time the package runs it takes good amount of time, than the other times it runs every day(if you have multiple times running in a single day).. Hope that answers your question.. Inka emanna untey cheppu... Intaki sqlsaga ki like pettinava leda man...
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts