InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 08 Nov 2009 01:20:06 GMT20http://www.sqlservercentral.com/Forums/Topic815191-147-1.aspxCan anyone recommend a good book that uses SQL Server 2008 as its examples?I want to learn datawarehousing and BI using SQL Server Analysis Services 2008.However, to get to the Analysis services point I would need a proper datawarehouse structure to start with.I am familar with SSIS, but only with the very basic data warehousing concepts.Is there a good book out there I can read through and work the examples to gain a better understanding of how to layout a warehouse and then build some cubes on top of?Fri, 06 Nov 2009 13:58:54 GMTMaxerhttp://www.sqlservercentral.com/Forums/Topic815363-147-1.aspxHihow to generate cube in analysis cube.plz send any help link to generate cube to coding in asp.net in business intelligence.hanks in advanceSat, 07 Nov 2009 02:57:18 GMTamirs-717937http://www.sqlservercentral.com/Forums/Topic815262-147-1.aspxHi All...I thought I was an SSIS expert but I don't feel like one now...I need to do a standard FTP upload of file(s) via SSIS...I would think this has been done a bazillion times through SSIS...First I added the variables necessary...Variable vDPKFilePath_FTP to "/dpk_import/" (backward slash for FTP)Variable vDPKFilePath to "C:\Dpk_Import\Files"I added an FTP connection and connected to my remote ftp server...ntbu.bydeluxe.comI tested connection and it works fine...The files live at ntbu.bydeluxe.com/dpk_importThen I added an FTP task to use this connection...Under file transfer tab...Remote Parameters:IsRemotePathVariable TrueRemoteVariable User::vDPKFilePath_FTPLocal ParametersIsLocalPathVariable TrueLocalVariable User::vDPKFilePath -> Contains C:\Dpk_Import\FilesOverwriteFileAtDest TrueOperationOperation Receive FilesAscii FalseNo expressions used...The FTP does not give the red X with a circle...Builds fine...When I execute task, it just goes yellow and does not do anything...I know this should be simple but I'm just not getting it...Could someone point me to an example that a 1st grader (cause that's what I feel like) could follow...Thanks a million in advance...HowardFri, 06 Nov 2009 17:25:46 GMTHoward.Veazeyhttp://www.sqlservercentral.com/Forums/Topic815236-147-1.aspxI have a dimension called position (a numeric field), which is sometimes used to cut by.But in this situation, I want the average position for a time period.Is it possible to use the average function on a dimension field (as opposed to a measure)?If so, please help.For Example, this pulls data:WITHMEMBER [Measures].[Position] as [Dim Position].[Dim Position].currentmember.nameMEMBER [Measures].[Avg Position] as AVG([Hotel].[Hotel Key].currentmember,[Measures].[Position])SELECT ({[Measures].[RecordCount],[Measures].[Position],[Measures].[Avg Position]}) ON COLUMNS , filter(([Date].[Calendar].[Date].&[2009-10-16T00:00:00],nonempty([Hotel].[Hotel Key].[Hotel Key]),[Position].[Dim Position].children),[Measures].[RecordCount]>0)ON ROWS FROM [Lodging]BUT it gives the average position for each position - which, obviously, is not helpfulI want the average position for each hotel.I want to remove the ,[Position].[Dim Position].children line from Rows, but then the MDX doesn't work.Any suggestions greatly appreciated.Thank you, MeganFri, 06 Nov 2009 15:59:31 GMTmveehttp://www.sqlservercentral.com/Forums/Topic813947-147-1.aspxHiwe changed our server name and now the link at the bottom of emailed reports still has the older server nameit looks something like this:The report is accessible at the following address:http://OLDServerName/reportserver?%2fProduction+Reports%2fSubscription+Traffic%2fAnalysis%2fTraffic+Info+-+By+Month&rs%3aParameterLanguage=en-USanyone know how to change that to the new server name (without full reinstall of SSRS)?thanksWed, 04 Nov 2009 18:42:03 GMTTodd Stuhttp://www.sqlservercentral.com/Forums/Topic814850-147-1.aspxhihow to convert RDL to RDLC for .Net integration i saw the below but it does not work for me.http://msdn.microsoft.com/en-us/library/ms252109(VS.80).aspxThanksParthiFri, 06 Nov 2009 05:15:13 GMTparthi-1705http://www.sqlservercentral.com/Forums/Topic814926-147-1.aspx[quote]SSIS package "Export EmpplyeeData.dtsx" starting.Error: 0xC002F325 at Export Data to OBbeaver, Transfer SQL Server Objects Task: Execution failed with the following error: "Property DefaultSchema is not available for Database '[EmpplyeeTest]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. ".Task failed: Export Data to OBbeaverSSIS package "Export EmpplyeeData.dtsx" finished: Success[/quote]I am getting the above error when trying to export table with data using ssis pkgs. I want to create a database and export all tables and data into it from the source db and my account has read/write and ddl_admin previlages.Fri, 06 Nov 2009 07:40:37 GMTTara-1044200http://www.sqlservercentral.com/Forums/Topic814782-147-1.aspxI am creating a SSIS pkg which fetches the data from DB2 and load it into SQL 2005 .Now while running it gives the following error...SSIS package "Package.dtsx" starting.Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.Error: 0xC0202009 at Data Flow Task, OLE DB Source [489]: An OLE DB error has occurred. Error code: 0x80040E00.Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component "OLE DB Source" (489) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "OLE DB Destination" (1686)" wrote 0 rows.Task failed: Data Flow TaskWarning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.SSIS package "Package.dtsx" finished: Failure.Please Help...Fri, 06 Nov 2009 03:11:21 GMTnitin.guglanihttp://www.sqlservercentral.com/Forums/Topic814759-147-1.aspxOur corporate currently has a medium sized (approx 500 GB) data warehouse in SQL SERVER 2005 and all SQL Server’s components database server, SSIS and SSAS are deployed to the single physical server. Considering the current performance and future growth management, we are in the process of re-architecting this BI infrastructure using SQL SERVER technologies. Could you please share your ideas/experiences/expertise on selecting the following design choices for designing a BI infrastructure for an optimal performance: 1. System Configuration : Monolithic (run all SQL Servers components in single physical server) OR Distributed (run all SQL Servers components to different physical servers)2. Data Storage: SAN or DASThanks in Advance.Fri, 06 Nov 2009 02:16:33 GMTesnkumarhttp://www.sqlservercentral.com/Forums/Topic814708-147-1.aspxHi what to doCase 1:I want to create a report with Microsoft Visual Studio Reporting Services,i want to type a Id in a text box and then have to choose fromdate and todateand press button submit i have created a SP to pass those parameters how to give that Text box input to sp i am using only SSRS (no .NET is here)Case 2:i have a RDL in Sql Reporting Services, now have to convert the RDL into RDLC of Asp.Net ThanksParthiThu, 05 Nov 2009 22:58:03 GMTparthi-1705http://www.sqlservercentral.com/Forums/Topic814664-147-1.aspxHere is my scenario. I have different set of SSIS packages for each module. When am deploying the first set of packages (1st module), I need to create two environment variables for config file path and root directory path. Now, when am going to deploy all other modules, I need to create 2 environment variables for each module. If I have 5 modules to deploy I end up creating 10 environment variables to specify the config file path and the root directory path where SSIS packages exist. Is there any other way of doing this without creating these many variables? Any kind of suggestions would be a great help!ThanksThu, 05 Nov 2009 20:26:08 GMTSravanti Vhttp://www.sqlservercentral.com/Forums/Topic814196-147-1.aspxHi Please helpThe following code is giving me a problem in that if it evalutes to true then it displays properly but when it evaluates to false it only display the first value if the field instead of all values in that field [code="plain"]=iif(parameters!Consolidate.Value = "(Retail Consolidate)", Fields!DisplayLevel.Value, Fields!Level3.Value)[/code]Please helpThu, 05 Nov 2009 06:41:26 GMTthatokhttp://www.sqlservercentral.com/Forums/Topic814091-147-1.aspxHi,I had run the cluster analysis package in SQL08 and noticed that it gave different cluster maps on each run although the same data was used repeatedly.Could some one explain why so?rgdsJoeThu, 05 Nov 2009 03:00:34 GMTmatrixjoehttp://www.sqlservercentral.com/Forums/Topic809488-147-1.aspxMy report pulls data from ssas 2008. I have a parameter that populates the drop-down by a query. By default ssrs adds a (Select All) to the drop-down and the mdx query also returns an All member as part of the result set. I need to remove one of the All parameters so the users aren't confused. Any ideas? I've tried a few things and haven't been able to successfully remove either one.Is there a way to filter the [All] member from the MDX result?Tue, 27 Oct 2009 11:30:13 GMTthehindshttp://www.sqlservercentral.com/Forums/Topic781643-147-1.aspxHi Community, Iam a starter in SSAS and SSRS. Cud someone tell me some good tutorial sites for both of them? And also wht else do i need to learn/know to be an SSRS developer? All responses are appreciatedThanks,AnandWed, 02 Sep 2009 10:52:05 GMTanand_1047http://www.sqlservercentral.com/Forums/Topic813413-147-1.aspxHi all, We have built cube using Analysis services and we are trying to restrict access based on Geographical location. We have implemented several roles to do that and it works fine while tested using BIDS in Visual Studio and SSMS. Actually we are using a third party web based tool for accessing the cube and we have developed a custom built .NET application to control the Log-ins. Now we would like to map these UserIds that the users provide during logins to different roles in SSAS and give access to appropriate data. Now we have given NT authority service, the rights to access the cube and the users access it through that account.Instead of this how to make them access the cube through the .NET application's credentials?Thanks in advance,ValliTue, 03 Nov 2009 22:07:06 GMTvallisaravananhttp://www.sqlservercentral.com/Forums/Topic813130-147-1.aspxI have scoured the internet looking for examples of SSIS packages being run from SSAS and how to set that up in management studio.I am very familiar with the protection level [url]http://support.microsoft.com/kb/918760[/url] article. I have decided to try setting my SSIS package to EncryptWithPassword as the protection level. I've left the password blank in the package properties.This time, I built the package under our administrative account. I also deployed the package to our production sql server as the admin account.Inside the SSAS job, in the step that runs the package, I attempted to modify the command line code by adding a /DECRYPT parameter with no password defined, but the command line keeps reverting to [code="other"]/SQL "\[package name]" /SERVER [production server] /CHECKPOINTING OFF /REPORTING E[/code]Am I defining the SSIS package password in the correct location?The reason I was having problems running the SSIS package from SSAS in the first place was due to the user permissions. The package stores and grabs data from several servers, but I beleive running the package as the administrative account should handle that.Should I just build the package with the admin account using EncryptWithUserKey and use that account to run it in SSAS. I've read that the machine you create it one if different than the machine running it can stop execution with that protection level defined.If anyone has a nice step by step for setting up a complex SSIS package to run automatically in SSAS, I would appreciate the info.Tue, 03 Nov 2009 11:51:42 GMTkwigganshttp://www.sqlservercentral.com/Forums/Topic813070-147-1.aspxHiI've been slogging away for a few days now and have hit a brick wall.Using SSIS 2005, I need a way to move a table from one database to another, including data. The problem is, there are 400 potential tables, and I don't know which one it will be until runtime. Basically the tables are datasets, and they vary in table definition and data volumes. The code is required to move certain of these dataset tables to a new copy of the database on a different server, for demos, testing, etc.But the tables required will vary from copy to copy, and so I'm looking for a way to parse the table at run-time.I've tried SQL Server Objects Transfer, and it leaves out the defaults,etc.Dont want to create data flow for each possible table as more are added all the time.Trying to find a way to do it in a script task maybe, even using script to create a new package / task programmatically.any ideas?Thanks guys n gals.BarriTue, 03 Nov 2009 10:15:11 GMTbarri_j_martinhttp://www.sqlservercentral.com/Forums/Topic464825-147-1.aspxI developed my package using BIDS and successfully tested it on local computer. On deployment to new server I have to run my package with command prompt utility.Initially i faced problem creating deployment installer from BIDS, there was an error like this that unable to copy the config file to deployment folder as it already exist.Though i can physically see the config file moved to deploy folder but the deploymentmanifest was not generated. Hence I did manual deployment. Below is error details.Error 9 System.ApplicationException: Could not copy file "C:\Project\IntegrationServices\SFRIntegrationServices\PCSConfiguration.dtsConfig" to the deployment utility output directory "C:\Project\IntegrationServices\SFRIntegrationServices\bin\Deploy". ---> System.IO.IOException: The file 'C:\Project\IntegrationServices\SFRIntegrationServices\bin\Deploy\PCSConfiguration.dtsConfig' already exists. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CopyFiles(ICollection fileNames, String outputPath) --- End of inner exception stack trace --- at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CopyFiles(ICollection fileNames, String outputPath) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CreateDeploymentUtility(IOutputWindow outputWindow) The MAJOR issue is after manual deployment the config file path is being used as one specified at design time. Please look into below error. H:\>DTExec /FILE "D:\DTS\Packages\pkgSFRLocation.dtsx" /SET \Package.Variables[InputParamFileName].Value;"D:\DTS\Input\PalletControl\LOC00022"Microsoft (R) SQL Server Execute Package UtilityVersion 9.00.3042.00 for 32-bitCopyright (C) Microsoft Corp 1984-2005. All rights reserved.Started: 9:15:40 AMWarning: 2008-03-06 09:15:50.89 Code: 0x80012012 Source: pkgSFRLocation Description: The configuration file name "C:\Project\IntegrationServices\SFRIntegrationServices\PCSConfiguration.dtsConfig" is not valid. Check the configuration file name.End WarningWarning: 2008-03-06 09:15:50.89 Code: 0x80012059 Source: pkgSFRLocation Description: Failed to load at least one of the configuration entries for the package. Check configurations entries and previous warnings to see descriptions of which configuration failed.End WarningDTExec: The package execution returned DTSER_SUCCESS (0).Started: 9:15:40 AMFinished: 9:15:54 AMElapsed: 14.172 seconds Last i tried specifying the path externally from dtexec options then it failed because my master config file has values for 3 variables (User::MailRecepient,User::CopyRecepient,User::Profile) which has not been declared in this current package(pkgSFRLocation.dtsx) I am trying to execute. These variables have values specified for other packages which share the config file. H:\>DTExec /FILE "D:\DTS\Packages\pkgSFRLocation.dtsx" /conf "D:\DTS\Packages\PCSConfiguration.dtsConfig" /SET \Package.Variables[InputParamFileName].Value;"D:\DTS\Input\PalletControl\LOC00022"Microsoft (R) SQL Server Execute Package UtilityVersion 9.00.3042.00 for 32-bitCopyright (C) Microsoft Corp 1984-2005. All rights reserved.Started: 9:25:42 AMWarning: 2008-03-06 09:25:43.98Code: 0x80012012Source: pkgSFRLocationDescription: The configuration file name "C:\Project\IntegrationServices\SFRIntegrationServices\PCSConfiguration.dtsConfig" is not valid. Check the configuration file name.End WarningWarning: 2008-03-06 09:25:43.98Code: 0x80012059Source: pkgSFRLocationDescription: Failed to load at least one of the configuration entries for thepackage. Check configurations entries and previous warnings to see descriptionsof which configuration failed.End WarningWarning: 2008-03-06 09:25:44.40Code: 0x80012017Source: pkgSFRLocationDescription: The package path referenced an object that cannot be found: "\Package.Variables[User::MailRecepient].Properties[Value]". This occurs when an attempt is made to resolve a package path to an object that cannot be found.End WarningWarning: 2008-03-06 09:25:44.42Code: 0x80012017Source: pkgSFRLocationDescription: The package path referenced an object that cannot be found: "\Package.Variables[User::CopyRecepient].Properties[Value]". This occurs when an attempt is made to resolve a package path to an object that cannot be found.End WarningWarning: 2008-03-06 09:25:44.43Code: 0x80012017Source: pkgSFRLocationDescription: The package path referenced an object that cannot be found: "\Package.Variables[User::Profile].Properties[Value]". This occurs when an attempt is made to resolve a package path to an object that cannot be found.End WarningDTExec: The package execution returned DTSER_SUCCESS (0).Started: 9:25:42 AMFinished: 9:25:44 AMElapsed: 2.265 secondsPLEASE HELP me resolve either these problems ...I am unable to undestand how to deploy this successfully. Wed, 05 Mar 2008 16:05:41 GMTkapoorneetuhttp://www.sqlservercentral.com/Forums/Topic812297-147-1.aspxHi,I need to write some t-sql to use for reports in SSRS 2005. The reports will be called from a front end application. In the front end users will select options (start date, end date, customer address in this or that country, all the usual kind of stuff) and a user's selections will be passed at runtime as report parameter values.So here's my question: does anyone have any tips or tricks for limiting the number of separate rdl files I have to create and upload to the report server? I can see for example that if I write a parameterised stored procedure which executes one query if the param value is x and another if the value is y, then call this procedure in a report, the report designer shows me only the first possible set of column headings to use in the report. But I don't want to create a separate report for every possible set of user selections.Thx in advance,LouiseMon, 02 Nov 2009 04:10:42 GMTLouise Boultonhttp://www.sqlservercentral.com/Forums/Topic693550-147-1.aspxSeems like pretty general problem-have report with pie chart that uses predefined color palette but would like instead control used colors, e.g. for Product1 - always Red, for Product2- Blue, etc. Certainly I can create product_color_map but how to force RS to use these colors (from map)- no clue. I know that it’s possible to accomplish using Dundas Chart, but without …Really appreciate any tips. Thanks, Wed, 08 Apr 2009 14:10:19 GMTYuri-199650http://www.sqlservercentral.com/Forums/Topic812782-147-1.aspxHi, I have three matrix table with more than 10 columns (well it is dynamic right). It seems fine at the beginning, but suddenly one of my matrix is disappears.but the weird is, if i refresh the report server page then it will return again.the same problem also occurs in my columns, sometimes it is duplicated and once again if i press F5 to refresh my report server page then it back to normal.is this a bug in SSRS 2005 or is there something wrong with my matrix datasource ?Tue, 03 Nov 2009 01:27:04 GMTtomysmilehttp://www.sqlservercentral.com/Forums/Topic785747-147-1.aspxHow can I setup my Table Report from the layout page to landscape and to fit A3 paper on the view or on the internet explorer when convertting to pdf formatThu, 10 Sep 2009 08:51:56 GMTpitso.macekehttp://www.sqlservercentral.com/Forums/Topic810755-147-1.aspxHi All,I have a folder on report manager with 5 reports.I created subscriptions for each report individually. This sends an email for each report with the report in the attachment.But, is there any way to send all the 5 reports in one PDF.Thanks,Thu, 29 Oct 2009 07:36:29 GMTUnionAllhttp://www.sqlservercentral.com/Forums/Topic544336-147-1.aspxI have an SP that extracts data to present in a report. The report was originally written in Crystal and works fine. I'm trying to write the same report in SSRS 2005. When I specify the SP as the query I get the message:There is an error in the query. Implicit conversion from data type sql_variant to varchar is not allowed. Use the CONVERT function to run this query.The SP defines a temp table, inserts a bunch of data from the DB into the temp table, updates rows selectively based on a couple of update queries, then selects the data out of the temp table and drops the temp table. The temp table definition uses explicit types for all columns (mostly varchar and int). Why am I getting this error in SSRS??Thu, 31 Jul 2008 06:50:07 GMTrschaeferhighttp://www.sqlservercentral.com/Forums/Topic812280-147-1.aspxHiI have a report in wich i hav parameters :1. Date Range (From date and To date)2. Status..There is a possibility of using one parameter at a time or can use both parameters at same time.Now i hav to use both the parameters to get the report.How can i make my parameters optional..??Mon, 02 Nov 2009 03:12:52 GMTnitin.guglanihttp://www.sqlservercentral.com/Forums/Topic812080-147-1.aspxHow do we run sql serever agent jobs for different time zones.For instance if a job is started in India at 11.50 pm on say Sept 12th it will be running upto Sept 13th and so it will log in data for two days... how do we process such jobs?Sun, 01 Nov 2009 00:27:47 GMTdebahuti_khttp://www.sqlservercentral.com/Forums/Topic812232-147-1.aspxHi ,Can anyone guide me on SSRS manual, scenario,unit testing?How is it done? what can be the probable questions for SSRS testing interview?Is there any website where I can read more about SSRS testing?Please do guide me.thanksMon, 02 Nov 2009 01:54:28 GMTdebahuti_khttp://www.sqlservercentral.com/Forums/Topic812233-147-1.aspxCan anyone provide me some important question and answers fro SSRS interview?Is there any website where I can find SSRS questions as well as ans?Please do guide me .thanksMon, 02 Nov 2009 01:56:00 GMTdebahuti_khttp://www.sqlservercentral.com/Forums/Topic811393-147-1.aspxhow do I acces the BIDS on a second or named instance of sql server 2005?Fri, 30 Oct 2009 02:18:02 GMTmangoalehttp://www.sqlservercentral.com/Forums/Topic811289-147-1.aspxGreetings,I am running the setup detailed below. During the install of the SSRS 2008 Add-In for MOSS 2007 I found that I must follow a custom install option (). This custom install has left it so that SSRS is running in integrated mode, meaning I can launch view reports inside sharepoint, however I cannot seem to find the web parts. Has anyone out there experienced this? If so what did you do to get the web parts installed?64-bit everythingWindows Server 2008SSRS 2008 SP1MOSS 2007 SP2SQL Server 2008 SP1Thu, 29 Oct 2009 16:48:18 GMTBen Sullins-437405http://www.sqlservercentral.com/Forums/Topic811881-147-1.aspxI've been struggling with this and am stumped. (Admittedly, I'm not good with MDX and cubes). I created a calculated measure as follows:SUM(PeriodsToDate([Dim Date].[Date].CurrentMember.Parent.Level, [Dim Date].[Date].CurrentMember),[Measures].[Posted Installs])Dim Date is a Date table with standard hierachy of Date, Week, Month, Quarter, Year. If I browse the cube and drop just Date into it, I get correct daily values, although Total is not correct, and if I try and aggregate by month,week, quarter, etc. the Total line has an error #VALUE! with hint:"MDX Script(UCUBE) (43,23) The MDX function cannot be applied because an agrument expression returned a null member"I've tried adding iif(IsEmpty()) into the script in a number of places, but it doesn't correct the problem, at least how I"m using it. Maybe it's because of where I'm placing it. Can anyone make a suggestion as to where it needs to be placed, or is there something else required? Help! SSAS NewbyFri, 30 Oct 2009 14:52:43 GMTPaul McCurdyhttp://www.sqlservercentral.com/Forums/Topic490774-147-1.aspxThis is probably an elementary question, but for the life of me I can't decide the proper direction to go with it.I simply need to create a report which shows only ten records per page. The incoming selection is unknown - may be only a few records, may be hundreds. Regardless of number of pages, must show only ten records per page.Is there a table limiting function in SSRS that I can use, or should I approach this with a stored procedure? Just looking for a kick in the right direction.Thanks!Fri, 25 Apr 2008 09:45:45 GMTMatt Brown-315969http://www.sqlservercentral.com/Forums/Topic811238-147-1.aspxI'm on SQL Server 2005 and have the following in my dataflow:1) OLE DB Source (sql table with a Description column nvarchar(200)) 2) Multicast3) Flat File Destination Additional Info:The Description column was initially nvarchar(100). I thought that by increasing it, it would fix it but it did not.The process fails when it encounters Japanese characters.The Error is:Data conversion failed. The data conversion for column "Description" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". Cannot copyor convert flat file data for column "Description". SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Flat File Destination" (16) failed with error code 0xC02020A0. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. Thu, 29 Oct 2009 15:09:59 GMTMelissaLevitthttp://www.sqlservercentral.com/Forums/Topic811104-147-1.aspxI've created a Report Model using Report Manager (SQL Server 2005 Reporting Services) based on an SSAS Data Source and am generating some reports based on the model using Report Builder.I am puzzled as to why I cannot see my Date dimension as an Entity under either of my Measure Group entities when it does appear on the 'Dimension Usage' tab of my cube. All of the other dimensions that appear on the 'Dimension Usage' tab also appear under the Measure Group entities as I would expect.The upshot of this is that I can't add any Date attributes to my report or filter by Date.I've made sure that the AttributeHierarchyVisible property is set to True for all the attributes in the Date dimension.What am I missing / overlooking?:unsure:Thu, 29 Oct 2009 12:34:40 GMTLempsterhttp://www.sqlservercentral.com/Forums/Topic811377-147-1.aspxhi,I have installed SQL server 2008 with advanced services on vista SP2. When I create a new report or analysis project and I want to add a new datasource or a new report , I have the following error:"Invalid at the top level of the document"Any clue ?ThanksChrisFri, 30 Oct 2009 01:23:17 GMTthaiafichttp://www.sqlservercentral.com/Forums/Topic498576-147-1.aspxHi,I have a SSRS report that has two report date parameters: Start date and End date. I would like to know if it is possible in SSRS to set maximum and minimum values for these report date parameters.Any help much appreciated.Mon, 12 May 2008 01:02:26 GMTuma thttp://www.sqlservercentral.com/Forums/Topic810321-147-1.aspxI'm extracting data from a table (on sql server) and writing it to a flat file. I'm getting the error below. I have already tried modifying my package to Delay Validation = True and TruncationRowDisposition is set to Ignore. When I saw that this didn't solve my problem, I examined the data finding out that I had Japanese characters in the table (which sql server supports) but it brought my package to a hault. The last row/column in the file is the column prior to the column contain the japanese character. What can I do? My file is Pipe delimited. Is this an issue with SSIS or with the Server that I am writing the file to?ERROR:SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Flat File Destination" (16) failed with error code 0xC02020A0. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. Data conversion failed. The data conversion for column "Description" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".Wed, 28 Oct 2009 14:33:53 GMTMelissaLevitthttp://www.sqlservercentral.com/Forums/Topic811203-147-1.aspxHi Everyone,I am using IIF statements to show/hide tablix columns based upon a parameter value. These statements are used as expressions in the visibility properties for the columns.If the parameter value is one that causes the column to be hidden, the coulmn does not appear on the report, but there is whitespace in its place.I have used this functionality very frequently in SSRS 2005 without the whitespace issue. The 2005 report automagically closed this whitespace up by moving the column to the right of the hidden one to now be adjacent to the column to the left of the hidden one at rendering. This is what i need to happen now in 2008.The columns this is happening on are the columns that display the values that the rows are grouped on. This doesn not happen on columns that display their contents stratight from the dataset.Has anyone else experienced this? If so, would you please share your solution? I am getting extremely frustrated by this...Thanks!!Thu, 29 Oct 2009 14:25:59 GMTaaron.thornberryhttp://www.sqlservercentral.com/Forums/Topic810609-147-1.aspxHi All, I am having a product dimension with product hierarchy that has the levels Product Line,Group,subgroup,brand and SKU and Supplier hierarchy that has Supplier Hierarchy, Brand and Sku. I need to calculate the Market share along the product hierarchy as well as manufacturer hierarchy. How can I create the calculated measure that works well with both the hierarchies?Now, it works only with the product hierarchy and the MDX query I had used isCase// Test to avoid division by zero.When IsEmpty ( [Measures].[Sales Value] ) Then Null// Test for current coordinate being on the (All) member.When [Dim Product].[Product Hierarchy].CurrentMember.level.ordinal=0Then 1Else ([Dim Product].[Product Hierarchy].CurrentMember, [Measures].[Sales Value] ) / ( Root([Dim Product].[Product Hierarchy].CurrentMember.Parent), [Measures].[Sales Value] )EndThanks in Advance,ValliThu, 29 Oct 2009 04:08:11 GMTvallisaravanan