Answer Questions

• Omar Fawzi Regarding DataMining in SQL Server 2005 Analysis Services

  Hi to all I have a complex scenario , so first I want to ask out the feasibility of it . I think its better if I state the scenario and some one on this forum reply to it , I need to build an application (e.g credit card application , Loan Application etc ) that requires some approval from expert , what I firstly want is that I apply datamining on this data so that next time when I enter the data the result (approval or reject ) should be given by datamining tool , this I gather is poosible by using Analysis Services in SQL 2005 , but I also want the bases of that decision ( I mean the rules/some thing else  that the Datamining created agaisnt the data entered ) , So can any one do any ...Show All

• Nick Waanders SELECT USER_NAME() !!!!! Urgent

  I wrote a trigger which writes to a audit table. To get the user name I use to use SELECT USER_NAME() this used to return something like a12345 this worked fine until we moved to production where the username also had the domin name with it . Now the output of the query is something like DOMAIN/a12345 t he value of "DOMAIN' is different for different users, and the "/" may or may not be present in the user name Can some one please give me code just to return the user name like a12345 Thanks a lot . There's a couple of different ways to do it, here's one way. create table #x ( nm varchar(20) not null ) insert #x select 'DOMAIN/a12345' uni ...Show All

• Mitch5713 For-Loop and Failed Items

  All, I am currently in the middle of writing a package that needs to loop round a record set and extract data from various source DB's in a common format. The inner package is a simple data pump that relies on a dynamic OLEDB connection being set at run time via a variable in the outer package. This works wonderfully, providing the value in the outer package points to a verifiable data source. However, If I make the data source invalid the execution status stops, In DTS 2000 this was simple to overcome with an Active X script, as you would set the package status to waiting and loop back to the next record. Waht i need to know is the object and property/method that will do this in SSIS, I've looked through BOL and theres ...Show All

• akaRickShaw Visual Studio with Analysis Services Solution Hangs

  I have an existing project that was fine before... now when I click on the "Calculations" tab it says "Loading..." and never loads. This also happens on the "Perspectives" tab. I tried uninstalling and reinstalling VS... reinstalling the BIDS projects... HELP! The fix I mentioned was aimed at fixing a broken solution, your issue sounds machine specific. It could be a problem with MSXML 6.0, maybe you could try repairing or re-installing it. Or, have you by any chance installed Office 2007 on this machine There is a known issue with Office 2007 and SSAS 2005 SP1, this will be fixed in SP2. I did a blog post on how to manually fix this (at your own risk), but there is also an "official" hotfi ...Show All

• Trevor E Hilder File and Spreadsheet Frustration

  Hi, Two problems / questions I could do with some help on please...... 1). How do you clear a spreadsheet before loading it I am sending a spreadsheet by Email on a regual basis. Each time I run my SSIS package the data is appended to that of the previous run. I need just the contents of this data load to populate the spreadsheet each time. I have tried various methods / techniques for achieveing this so I just need to know the accepted method. Sorry if this is very basic ( as it should be !) but I seem to be missing the point somewhere. 2). I have tried to resolve issue 1 above by having an empty 'template' spreadsheet and copying that one over the top of the previously populated one. I get an error saying that the source spreads ...Show All

• rajesh_batchu Number of nonempty cells in a collumn

  Hello! How can I find "Totals" of rows with filled data E.g.: Date1 Date2 Date3 Date5 Date6 Date7 date8 1-Jul-06 2-Jul-06 5-Jul-06 10-Jul-06 11-Jul-06 2-Jul-06 3-Jul-06 6-Jul-06 11-Jul-06 3-Jul-06 4-Jul-06 7-Jul-06 12-Jul-06 4-Jul-06 5-Jul-06 8-Jul-06 5-Jul-06 6-Jul-06 9-Jul-06 6-Jul-06 7-Jul-06 7-Jul-06 8-Jul-06 9-Jul-06 10-Jul-06 Totals: 10 6 5 3 1 ...Show All

• kageg Which Data Flow task to use?

  I have a table which has been loaded from various source feeds. The SourceId relates to the source name and the SourceCompanyId is the sources primary key for the company. I am basically trying to create one row with all the SourceCompanyIds in my column headers. What data flow tasks would be necessary in SSIS The structure of the final table is: CREATE TABLE [dbo] . [Company] ( [CompanyId] [int] IDENTITY ( 1 , 1 ) NOT NULL, [CompanyName] [varchar] ( 75 ), [CIK] [varchar] ( 10 ), [Ticker] [varchar] ( 10 ), [Source1CompanyId] [int] NULL, [Source2CompanyId] [int] NULL, [Source3CompanyId] [int] NULL, [Source4CompanyId] [int] NULL, [Source5CompanyId] [int] NULL, [Source6CompanyId] [int] NULL, CONSTRA ...Show All

• GeKe Replicate only schema...

  Hi, I am relatively new to replication. I have a rather dumb question. I have two SQL Server databases, If i make a change in the first database schema, i want it to replicate to the second database. i dont want the data to replicate though. Is this possible Thanks, Raj Hi, What means "the simplest way is to add a horizontal filter that removes all rows" the filter must return 0 row Hi, SQL server 2005 transactional replication supports replicating schema change. You might want to read through BOL "Making Schema Changes on Publication Databases" ( http://msdn2.microsoft.com/en-us/library/ms151870.aspx ) to review what kind of ...Show All

• Mantu Singh Problem exporting to excel

  Hello, Im using SSRS and i made a report that has a huge quantity of data, and when i want to export it to excel i got the following error. Server Error in '/Reports' Application. Does your report have more than 65,536 rows in it Jarret Hi, No it hasn't, i found out the problem. It was two cells in the matrix that were hidden, once i made them visibile again, it worked. Thanks for the work anyway ...Show All

• michael aird Is this SQL related problem??

  Any idea the cause of this error. I got it while trying to execute a stored proc (in sql 2005). I had just restored database and below error is stucking me to move ahead. Any help please Error invoking method 'ExecuteQuery' for transaction (Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding) Timeout means that the server does not replies or completes the job within 30 sec (default) Are you sure the the database is online Can you execute a simple query such as select @@spid without having error Can you post the query ...Show All

• jerryf65 Minimum MDAC Version Requirement (Error)

  Hi everyone; I'm just getting started. I'm on Window 2000 pro with service pack 4 etc... I installed " C# " and " Microsoft Visual Web Developer 2005 Express Edition " -thats fine. I then installed " Microsoft SQL Server " (SQLEXPR.EXE) it was good until it did a check: Everything checked and passed fine except for the 2nd to last one: - Minimum MDAC Version Requirement (Error) Messages * Minimum MDAC Version Requirement * The system does not have the required version of Microsoft Data Access Components (MDAC) for this SQL Server release. For details, see Hardware and Software Requirements for Installing SQL Server 2005 in Microsoft SQL Server Books Online. - Edition Change Check (Success) Mess ...Show All

• faraaz_malak_c92eb4 Stored Pro Question - add parameter

  I want to know if I can simplifer the code like this Style in SP, Becuase if I have many parameter, I don't want the SP code repeat and repeat , THX. SQL = " ItemCode, Qty, WareHouse, Status from Inventory" IF @itemcode <> "" Then SQL = " Where itemcode = '" & @itemcode & "'" IF @Warehouse <> "" Then SQL = " and WareHouse= '" & @Warehouse & "'" Original SP : CREATE procedure dbo.InventorySelection @itemcode nchar(15), @warehouse varchar(4) as set nocount on if (@warehouse is null) or (@warehouse = '') SELECT ItemCode, Qty, WareHouse, Status FROM Inventory WHERE (itemcode = @itemcode) if (@itemcode ...Show All

• Rolan 0 aggregations was designed (0% optimization)

  When I try to design aggregations it always produces 0 aggregations. what am I doing wrong You might find this article on my blog useful: http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!907.entry As Thomas said, 0 aggregations could be due to the way you've designed your attribute relationships; it could also be the result of other things, such as the the number of members on each attribute. Chris If you are running SSAS2005 it can depends on that you have not designed any attribute relations in you dimensions. When you run the aggregation wizard you will see a tab before the aggregation process starts, where you count dimension members on each dimension level, as well ...Show All

• Runnur Convert SQL 2005 to SQL 2000

  I started a project using SQL 2005 and now the customer has decided they can't go to 2005 yet so I need to convert it back to 2000.  I didn't use any new features of 2005.  How do I move it back to SQL 2000 There is an easy way to solve the problem. Open the Microsoft SQL Management Studio, then in "Object Explorer" right click on your Database->Tasks->Generate Scripts In the Wizard Script Window Click Next, Select You DB, Click Next and in the Choose Script Option Step, Change the value of "Script for Server Version" from "SQL Server 2005" to "SQL Server 2000" and go on. When you click "Finish" button, your script will SQL 2000 compatible. Good luck. ...Show All

• Xaid sql data types vs is data types

  Hi, I want to store a decimal value which I get from an execute sql task into a package variable. Which data type should I specify when creating the package variable Thanks, Tom Glad to know that about the max function, but the original question of this thread was: what about decimal values I tried some things out and seems to me that every time I have decimals in a data set and I want to store them in package variables I have to do a data conversion. If I want to restore them in the database, I have to redo a cast from double to decimal. <<Dirty old way of programming >>   I don't know how others think about this, but I follow the thought that microsoft just 'forgot' about this data type. Che ...Show All