Answer Questions

• lordali Recovery Model to be used for a Data Flow Task

  Hello there I have a SSIS 2005 DTSX Package which has several Data flow tasks which directly dump data between tables from 2 different databases. Suppose if my destination database is named, DestinationDB, what recovery model should I select for this database so that my ldf file size does not explode I want to keep the ldf file as small in size as possible. Currently I have used Simple Recovery model, and the ldf file size goes to around 80 GB. (Inserting around 200 million rows) Will Bulk Logged model be a better option Also what does a SSIS 2005 Data flow task use internally (Insert operation or some sort of Bulk Insert between DBs) Please help. Thanks for the response. Does the fast ...Show All

• Mike D12995 An internal error occurred on the report server

  hi I'm using custom authorization to check the access permissions of the user. In report manager i'm getting the error as "An internal error occured on the report server". "The input stream is not a valid binary format. The starting contents (in bytes) are: 06-05-00-54-00-00-00-02-01-00-04-80-34-00-00-00-44 ..." In Custom authorization i'm getting this error, Please help me in resolving this issue. If i'm using the Report server URL http:\\localhost\reportserver then its working fine. The problem is only with report manager. what might be the issue. Regards uday ...Show All

• Jassim Rahma Where the data source and reports stored in reporting services

  Hi, I am wondered after creating a data source into the reporting services where the details of that data source stored in the backend, is it saving in the tables or somewhere else I need the details. And even i would like to know after uploading the reports where these details are also stored. This is little urgent, please help me. With Regards, Prashant Mulay The information is stored in the ReportServer catalog database. The tables and names of columns are readily identifiable for the purposes they server. All stored data that is related to passwords and users is encrypted. Hi Brad, Thank you for the reply. I want to create a small tool from where user can upload the report. I ...Show All

• Nasir_khan_persistent checking report expression syntax

  Hello! I have a report that I am writing that was displaying perfectly, until I had to add in group totals and "sum" some of the expressions. When I did that for some reason it over rode the "format percent" part of the expresson and is no longer "formatting as a percent" Any tips of where I could go to get my syntax in order Any help would be appriciated!! Ok that actually worked....awesome thanks!! This is one of the expressions Im using : Sum(Val(FormatPercent((Fields!ID30_DaysCNT.Value/Fields!TOTAL_UPB_CNT.Value),0))) This among many other things in this report are making me crazy!! Thanks for any input :) ...Show All

• Yorker .net version of Detect Anomalies in Excel

  Is there an e quivalent or similar .net sample for detecting data Anomalies Detect Anomalies in Excel http://zones.advisor.com/doc/14413 This tip http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/861.aspx gives the basic idea. You can also check out the live sample at http://www.sqlserverdatamining.com/DMCommunity/LiveSamples/46.aspx that shows anomaly detection in a web application - source code is provided. The Excel Addin adds the automatic creation of a mining model with some nice heuristics for column selection, and the visualization part. Those are mostly dependent on your application and the Excel code wouldn't really help I believe. The two sources above should give you ...Show All

• thiaygu Loading excel file(.xls) into sqlserver (ASP.net web application)(ASP.net framework 1.0)

  I am using framework 1.0 to do the above tasks. Since there is no fileupload function in .net 1.0, i will be using the html control tools (file field) to do the upload option. i have totally no idea of how to start coding it...can anyone guide me through the steps thanks i think i should explain my project... i am doing a web application... Scenario: User goes into the upload page. User selects file to upload through the html control "File field" user press upload button... the upload button should trigger the codes to load the selected .xls file to the database thanks It's not clear from your description why Excel ...Show All

• jambi How to reference a dataset passed to script

  Hi, I have a dataset created via the Execute SQL Statement control and wish to pass it into a script control that within the vb.net script I wish to perform different functions to it. The main goal is to take the dataset loop through it and record values into an array then take that array and loop through that so I can send an email containing the information within the array. Can anyone help I know that method and that won't work for what i'm trying to do, or at least i don't think so. All I want to know is how to reference a dataset from an execute sql statement within a script component. I wish to reference this dataset within the script component and loop through and create an array with specific inf ...Show All

• polymorphicx Newbie question RS API

  Functions... lines that start with = Is there a list of these functions (switch, Iif, etc..) that are for RS online somewhere Something like a Java API for example Excellent! Thank You Teo Lachev! You can any use any VB.NET function (or C# if you use a custom .NET assembly). There are RS-specific functions . ...Show All

• RAYMOND KNIGHT Execute Package Task and Configuration Files

  Hi all For selecting different load targets we use package configurations to override the connection parameters in the connection manager. To organize the different tasks we splittetd our load processes into multiple package files (dtsx) which are then put together into a workflow using "Execute Package Task" component. With the option /CONFIGFILE its possible to override the configuration file for the package that is called with DTExec. Unfortuanetly it does not override the configuration of subpackages calles by the "Execute Package Task". Are there some ways to configure subpackages on the command line Thomy Thomas Mutter wrote: Hi all With the option /CONFIGFILE its possib ...Show All

• Nassir Combine raw files using range

  HI, I have a dataflow that has two raw files as source and I would like to merge them upon a range condition: RawFile1.Date <= RawFile2.Date Usually, using tables, I would have used a lookup with partial cache to achieve it. Now, since we cannot use lookup transform with raw files, I was wondering how I could achieve this using raw files as source. Is it possible to merge raw files using merge or merge join Thank you, Ccote HI, I would like to be able to do basically the same thing as I can do when I join tables: Be able to join on col1 <= col2. One way to achieve this would be being able to to <= (or <>, <, >, etc.) when I use merge join transform. Or,by being able to lo ...Show All

• Eric Patchen Report Parameters and NULL

  If I want to filter a field that contains null, it doesn't show on the report. Example: Let's say I want to show all the customers of the company and I want to have a parameter called amount, which filters the amount that those customers have purchased from the company. The problem is though, if a customer has not bought anything yet (so the amount is null) or one of the employees of the company mistakenly has put a 'space' in the amount filed (so the amount is no longer null, but it's an empty string) it doesn't show up in the report unless I say : CASE WHEN Amount = '' THEN '[NA]' ELSE ISNULL(Amount, '[NA]') END AS Amount   and also include ('[NA]') in the dataset that amount parameter is populated from: SEL ...Show All

• blange Quorum & MSDTC Cluster Questions

  We are trying to setup a Windows Server 2003 Cluster with 2 systems and a DAV. We intend to install SQL 2005 on this Cluster. We purchased a DAV with 3 physical disk arrays as follows. 73GB RAID 1 (our plan is to use this to store sql transaction logs) 146GB RAID 1 (sql backups, temp database & other temp files) 420GB RAID 10 (sql databases) Now as we are setting all this up we find out we need a shared physical drive on the DAV to store the Quorom. It is my understanding we cannot partition the physical drives and use one of the partitions to store the Quorum because when you create the resource for the Quorum the resource is the phsyical disk not the partition. So my question is, is it in our best interest to buy a seperate ...Show All

• Njofra multivalue parameters - is this possible ??

  i am trying to build a report that uses multivalue parameters - the report is a simple listing report that lists out a list of cases as a table - the data is obtained from a view which just returns all details for all cases there is no user input for the selection details - am going to be calling the report and passing over the parameter values directly to it. there are several parameters for the report - they all default to "All" for each of these parameters, i need to be able to either use the default value of "ALL" or to enter a list (comma separated ) q1) could i just enter the list as a string comma separated list (rather than as multivalued parameters) and then use this list to filter the data usin ...Show All

• jlucas777 Data Mining Add-Ins doesn't work with non-English regional settings

  I tried Data Mining Add-Ins for Office 2007 - CTP December 2006. Test settings: Windows XP SP2 english with Italian regional settings, Office 2007 english (RTM), SQL Server 2005 Developer (with SP2 CTP Dec06) and Data Mining Add-ins for Office 2007 (CTP Dec06). If I keep regional settings in Italian, I get error like this: Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD)) If I change regional settings to English, the Add-in works. I found this description as the possible cause of the problem: http://msdn2.microsoft.com/en-us/library/ms178780(vs.80).aspx - if this is the issue, it would be necessary to change the ExcelLocale1033Attribute on the component. Is there another workaround ...Show All

• KitGreen sp_xml_preparedocument VS nodes()

  I am considering converting a stored proc which uses sp_xml_preparedocument to a select using the node() syntax. I made two sql scripts, one of each method with identical input xml and ran a query plan on each of them. To my surprise, the Sp_xml_preparedocument seemed to produce the better query plan. The Estimated subtree cost for sp_xml... was 3.36433 for 10000 rows and the estimated subtree cost for nodes() was 421.126 for 60 rows. Am I missing something or is sp_xml_preparedocument still the best method to shred an xml document sp_xml code: DECLARE @idoc INT , @trans_id int , @after_doc xml , @record_type int , @sm_session_id nvarchar ( 50 ), @trigger_start_time datetime , @user_id int , @fo ...Show All