dotnetrockz Posted April 7, 2014 Report Posted April 7, 2014 ssrs lo report build chesestapoudu how much hand written SQL is involved vs tool generator ? U need query writing,stored proc writing skills.....most of the time it will be stored procedures
loveindia Posted April 8, 2014 Author Report Posted April 8, 2014 can u explain breifly what are sub reports and in which scenario we use those? As name suggests Sub report is nothing but a report inside a report, but its values are triggered by the main report. so if you think all cricket playing nations names are the main report, the sub report underneath it will have all the players details, once you click on a particular team name, sub report starts changing. but in SSRS people mostly use it with Pie charts / Bar charts as sub reports. But with the advancements of PowerPivot and Sharepoint / Performance Point, SSRS sub reports are less likely used unless required. If you have more questions let me know..
loveindia Posted April 8, 2014 Author Report Posted April 8, 2014 Iloveindia have a question ntext (casted to varchar(max)) source column and im doing some cleaning using regular expressions in the scriptcomponent , conversion of ntext to dt_str,dt_str max is 8000 characters, but my source is more than 20k characters so in the target everything after 8000 is being cut off. is there a way to get all the 20 characters .. target varchar(max) please give your inputs. VARCHAR(MAX) is 2GB of data man.. are you explicitly writing 8000? Does your query have PRINT in it? or are you writing using a SELECT.. Need more info...what version of sql server???
powerstar02 Posted April 8, 2014 Report Posted April 8, 2014 VARCHAR(MAX) is 2GB of data man.. are you explicitly writing 8000? Does your query have PRINT in it? or are you writing using a SELECT.. Need more info...what version of sql server???:)
loveindia Posted April 8, 2014 Author Report Posted April 8, 2014 ssrs lo report build chesestapoudu how much hand written SQL is involved vs tool generator ? When you say tool generator, I am thinking Query Builder.. Chinna chinna straight queries ki you can use query builder. Most of the times requirements are not straight, so you need to have good understanding of either SQL / MDX depending on the database system you are working with. ssrs lo job cheyali ante compulsory ga ssas or ssis nerchukovala? SSIS is for ETL and SSAS is for arranging the data inside a OLAP cube.. SSRS is a tool to display that ETL'ed data from a data warehouse. So you need to atleast a 6 out of 10 knowledge.. but if you have SSRS + Sharepoint + Powerpivot, then you will need to know for sure...
loveindia Posted April 8, 2014 Author Report Posted April 8, 2014 :) neeku em aindi man, ala navvutunnav...
DaleSteyn1 Posted April 8, 2014 Report Posted April 8, 2014 question for you SSIS data flow task lo source table ni dynamic ga populate chesthuna so destination kooda dynamic ga source batti create chesthuna.Okasari run chesthe everything is fine.Suppose a table structure change ayindhi anuko second run lo a kotha strucutre teeskovatledhu default ga metadata lo first run lo unna structure ni teesukuntundhi which is causing failure of package.Manual ga refresh undhi through gui adhe settings or any workaround to autorefresh the metadata everytime i run the ssis package
loveindia Posted April 8, 2014 Author Report Posted April 8, 2014 question for you SSIS data flow task lo source table ni dynamic ga populate chesthuna so destination kooda dynamic ga source batti create chesthuna.Okasari run chesthe everything is fine.Suppose a table structure change ayindhi anuko second run lo a kotha strucutre teeskovatledhu default ga metadata lo first run lo unna structure ni teesukuntundhi which is causing failure of package.Manual ga refresh undhi through gui adhe settings or any workaround to autorefresh the metadata everytime i run the ssis package unfortunately no man... the mappings have to be established and if there is no correct metadata available, that is change in columns it will fail, you have to manually do a refresh...
DaleSteyn1 Posted April 8, 2014 Report Posted April 8, 2014 unfortunately no man... the mappings have to be established and if there is no correct metadata available, that is change in columns it will fail, you have to manually do a refresh... there is a solution will let you know tommorrow once i implement it wanted to know how you would implement and if it was a better method thought of using it
loveindia Posted April 8, 2014 Author Report Posted April 8, 2014 there is a solution will let you know tommorrow once i implement it wanted to know how you would implement and if it was a better method thought of using it as far as I know it, if you have a change in the metadata all you can do is reload the package man... Just refreshing the package by an external source wouldn't work.. This is what i know.. if there is anything new, I am definitely up to learn it.. Sorry if I guided you wrong though...
DaleSteyn1 Posted April 8, 2014 Report Posted April 8, 2014 as far as I know it, if you have a change in the metadata all you can do is reload the package man... Just refreshing the package by an external source wouldn't work.. This is what i know.. if there is anything new, I am definitely up to learn it.. sorry if I guided you wrong though... there is a workaround for it will update tommorrow once i run it successfully
loveindia Posted April 8, 2014 Author Report Posted April 8, 2014 there is a workaround for it will update tommorrow once i run it successfully ok will wait for it man... which version of Sql server is it?
DaleSteyn1 Posted April 8, 2014 Report Posted April 8, 2014 ok will wait for it man... which version of Sql server is it? sql server 2008r2
DaleSteyn1 Posted April 8, 2014 Report Posted April 8, 2014 i have another question for you dude in sql server 2012 do you how to run a complete ssis project from sql agent by passing variables to the ssis project itself
Recommended Posts