Answer Questions

• Jan Meeusen Installation to different folder issue

  I have only SQL engine installed to my D drive. (SQL Server 2005 no SP1) I want to install SSIS to my D drive but i can not. It only gives me the option to install to the default drive C:\... saying that "the sql shared path has already been configured" Is this a BUG No Tools nor Notification Services are installed (which i understood to be related to the same path as SSIS) thanks, raviv there is an advanced option. but the changing of the path is disabled since it says: "the sql shared path has already been configured" but as this article indicates there must be a way to configure it: http://msdn2.microsoft.com/en-us/library/ms143547.aspx at ...Show All

• LokiSD SCD component - is there an alternative?

  Hi, I have several SCD components in my project. As I have to process millions of records, SCD's are taking a lot of time. Is there a way to speed them up Work arounds Any tip is welcome -Tom Really stupid I can't show any screenshot here... I have an OLE SRC component with a query like: select A.xField, A.yField, A.zField, B.zField as HaveRecord from TableA as A left outer join TableB as B on A.zField = B.zField with the data flow I go to a CSPL component with the function ISNULL(HaveRecord) the data flow with all the records where HaveRecord was null (=new records), I connect to an OLE DST component where I use direct insert - fast load, with TableB as destination table. I map all the A-fields Wehn I execut ...Show All

• OmegaMan Unable to start SQLEXPRESS

  Hi I have downloaded and installed the trial version of MS Visual Studio 2005 Team System. The installation was successful. However, I am not able to start SQLEXPRESS using the SQL Server Configuration Manager. It shows me SQLEXPRESS but when I right click and select Start it tries to start the service and after some time gives the following error "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details." The event log shows the following errors: 1. FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf'. Diagnose and correct the o ...Show All

• NoSTaBoNN Guest principal assigned to Datareader Role does have access

  Hello (help), In SQL2000, when the Guest account was assigned into a role, such as db_datareader, then querying across databases worked just fine. Specifically: I have a Report Writer application that connects to the SQL Server with a login (ReportRunner) that actually has very limited permissions on a database. The connection is then set (sp_setapprole) to use an Application role (App_RR) that has the necessary permissions. The report-writer app calls a Stored Procedure that gathers data from several other databases (on the same SQL instance). In SQL 2000, accessing these other databases was done through Guest - we assigned Guest to the db_datareader role. All worked fine. We've just upgraded to SQL2005: reports started failing. ...Show All

• dbldown768 Is ProcessAdd done within a transaction mode?

  Is ProcessAdd done within a transaction mode This question is very basic. When you do a ProcessAdd, is it within a transaciton mode I mean, if the ProcessAdd fault and stop when it meets a mistake, the records before the midstake will still be in the cube or not. Thanks. Thank you, Mosha. You're right. I know how to do a begin transaction Task and a Commit Task in SSIS Excute SQL Task. Could you tell me how to do a begin AS transaction Task and a AS commit Task You mentioned to use AMO to make a self-difined controller. Please tell me more about this or give me some articals about this. I have no idea about that. Thanks a lot! ...Show All

• PadamPadam sql server install problem

  I am planning to work with replication topic and i have a problem with it. I have installed a SQL server 2005 standard edition.When i try creating a new publication it comes out with this error "Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of sql server. for information about installing replication,see installing replication in sql server books online Additional information: Execute permission denied on object 'sp_MS_replication_installed",database'master',owner'dbo'. (Microsoft SQL server ,Error:229) I have tried inserting the CD and reinstalling it.but didnt work. When i tried to Remove sql server from control panel add/ ...Show All

• Azriel Cross Navigation on Matrix Subtotal

  Here's a sample matrix: Men Women Total Full Professor 36 12 48 Assoc. Professor 16 9 25 Assistant Professor 11 14 25 Total 63 35 98 Now, it's easy enough to make the values clickable so that somebody can drill down to a report that shows detail about the people. I have also discovered how to turn off clickability on the totals. However, what I really want is for the totals to be clickable so that, for example, if I click on the 63, I see a report that shows all men. Likewise, If I click on the 48, I want to see a report that shows all Full Professors. What currently happens when the totals are clickable is that if I click on the 63, I get all men who ar ...Show All

• WL_07 Date Format Conversions in SSIS

  Hi I am quite new to SSIS and have been given the task of importing some data from a text file into the database. The data contains dates which are in the American format of mm/dd/yyyy. I need them in the datadase in the format of dd mon yy. I realise I could load it and do a SQL task to convert once it is in the database but ideally i would like this data transformed before it is loaded into the tables. any suggestions will be gratefully recieved. Best regards It's just string manipulation. Add a derived column transformation, and manipulate the input string (using SUBSTRING, etc.) into a new column, casting it as the appropriate type. Greg. ...Show All

• Perry Choy Error 1 Memory error: The operation cannot be completed because the memory quota estimate exceeds the available system memory.

  I get the following error when trying to process a cube on the server. Error 1 Memory error: The operation cannot be completed because the memory quota estimate exceeds the available system memory.    0 0  It runs on a Microsoft Windows NT 5.2 (3790) with the JUNE SQL 2005 Developer release. I has 4 gigs of RAM This error comes when trying to process all sizes of cubes. The document that you suggested is the document that I read prior to modifying my AS properties. The property that actually made it possible to process the partition was an undocumented property OLAP \ Process Plan \ MemoryLimit. I agree that increasing the amount of memory available was probab ...Show All

• Antti Nivala Instant Message Delivery Channel

  Hi, I am developing a delivery channel to send instant messages that invoques some methods of a library, the other library is a com object and the method tha I Invoque is called Login. Thre thing is that this Login method executes asynchronously and fire some event to say that it has finished the login process. In the event I write the code to send a message for example. So far everything is ok when I invoke the method from a windows or web app, but when I call the method from wthin the deliverychannel the event apparently did not get fired or it does not return to the delivery channel Here is the code in the Deliver Notification method, and the event handler public void DeliverNotification(ns. NotificationHead ...Show All

• tiberious Export to a Text file in SQL Server Express

  I have a table in a database has the same filed with a text file: RBW_AR_BOT_REC Size Comment Justification Padding record_id 1 'R' None None date 6 MMDDYY None None time 4 HHMM (24 hour time) None None cust_num 8 1 - 9999999 Right Zero odometer 6 0 - 999999 Right Zero receipt 8 1 - 99999999 Right Zero exception_customer 1 '0' = No '1' = Yes None None valid_void 1 '0' = valid 'v' = void None None Justification Padding ...Show All

• Sparks260 Restoring database problem

  i have developed an application where in one form i placed two buttons, backup and restore. when i want to take backup from database to which i currenly login, i can . But when i want to restore database that bakup to database to which i currently login, i get an exception. So then add following method myConnection.Close() RestoreBackup(); even though it is not restoring. the resore backup method is following public void RestoreBackup() { // If there was a SQL connection created if (srvSql == null ) { Connect(); } if (srvSql != null ) { openBackupDialog.InitialDirectory = "./Backup" ; openBackupDialog.DefaultExt = "bak" ; // If t ...Show All

• jonam Converting negative integer from string to int

  I'm having an issue using the data conversion task and trying to convert from a negative integer that is bounded by brackets e.g, (1) for -1. I keep getting an error that the value cannot be converted although I've tried all signed integer types. If there are positive numbers in that column as well, you may need to place a conditional split before the derived column; and then, as Jamie suggested, use an expression (in a derived column transform) to remove the brackets and to multiply the resulting number by -1 so you get the negative sign. Thanks Darren, I'm going to give that a try. It's bizarre because I have a DTS in SQL 2000 and it handles this issue without any problem or conversion issues. ...Show All

• Gordon Staley How to concate 2 ore more text fields into one field?

  Hello, I hope someone has already done this, but I have a table with a text column- example ColA, now i want to run a query to select the ColA in this table and combine the results of ColA into a ColB in another table. Something like - Note: the codes below doesn't work!! DECLARE @ResultID as int DECLARE @AccID int DECLARE _rows CURSOR FOR SELECT AccID FROM tableA FETCH NEXT FROM _rows INTO @AccID WHILE (@@fetch_status <> -1) BEGIN UPDATE TableB SET Report = Report + (SELECT txtField FROM tableA WHERE AccID = @AccID) WHERE AccID = @AccID FETCH NEXT FROM _rows INTO @AccID END Thanks in advance Check this link that Jared Ko provided earlier today: http://databases.aspfaq.com/general/h ...Show All

• M. U. KPI that compares the growth over years

  Hi there, I'm new to SSAS and MDX. Creating my first dimensions and cubes went fairly fine. But now I hang on KPI. I'm trying to create a KPI which shows the growth of bookings comparing one year to the previous year. I want to set a fiterexpression for the time-dimension (e.g. YearString equals 1998). If a filter is set, it should show the bookings for that year ([Measures].[Bookings]) as value and the bookings of the previous year as goal. My problem is, that I cannot access the selected YearString, to get the bookings of the previous year. I tried the function parallelPeriod() and also a self-created Calculation, but it seems that [dimension time].[hierachy].CurrentMember is always [dimension time].[hierachy].[(All)]. My data structure ...Show All