JammichettuPandu Posted March 25, 2014 Report Posted March 25, 2014 DB useful Ankuls lo nuvvu kuda pradama varsalo vuntavu love India Garu
Darling999 Posted March 25, 2014 Report Posted March 25, 2014 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... Thanks Doode, got the answers. yeah pettinaa like
libraguy863 Posted March 25, 2014 Report Posted March 25, 2014 why are you passing it to the query one value at a time?? if you have 10000 values, that means it is 10000 loops... can you not have all that values into a table and use a join directly over that table... which will eliminate looping....??? are you passing that variable value to a direct sql query???? believe me this way will be 10X faster than what u r doing now.... yes thats a very straight fwd process, but i want the table names to be dynamic, like any table with the list passed thru the procss shud generate a list of records in my tgt tbl
loveindia Posted March 25, 2014 Author Report Posted March 25, 2014 Thanks Doode, got the answers. yeah pettinaa like I love you man.....
loveindia Posted March 25, 2014 Author Report Posted March 25, 2014 DB useful Ankuls lo nuvvu kuda pradama varsalo vuntavu love India Garu
Pillazamindhar Posted March 25, 2014 Report Posted March 25, 2014 yes thats a very straight fwd process, but i want the table names to be dynamic, like any table with the list passed thru the procss shud generate a list of records in my tgt tbl Using Expressions in the SSIS variables, calling the variable in the script task to generate the loop and then you can create dynamic table names to populate the target table.
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts