Answer Questions

• davidvo profiler can't save trace to file

  sql2005 can't save profiler trace to file (check box always unchecked), save to db works fine. loged as local admin. I dont understand...all you have to do is check the box and the New Trace dialog will prompt you for the file to save the results to Derekg I soon as I remove cursor from from checkbox it become uncheked I'm the Program Manager who owns Profiler. This is the first I've heard of this issue. I apologize for the frustration this causes. Could you give any more information about the issue Could you download the Windows Media Encoder , record this behavior, and upload it to http://connect.microsoft.com That i ...Show All

• Jocker23 Don't want to use cursors but no way around it

  During my long SQL-carreer I've managed to steer clear of Cursors. But now I have a project at hand where I do not see a feasable way to NOT use a cursor. From a pool of available numbers (IMSIs) I need to allocate new ones and add them to a batch table. In total there are three tables affected by the following SP. A batch table storing info on the batch, a table that contains the newly allocated IMSIs and a table holding all IMSIs with a state field to indicate that they are free or not. With in the WHILE loop I need to set the state from 'F'(ree) to 'A'llocated and I have no clue how to update the ImsiCursor. So two questions: Can this be done without a cursor How to update the State attribute of the current cursor location ALTER ...Show All

• watch is Connecting to pervasive via ODBC

  Has anyone successfully imported data from pervasive over the .net managed odbc bridge Our admin has set up a odbc connection that works through Excel, but in SSIS the connection manager errors when trying to connect at runtime (the "test connection" button in the connection wizard reports that everything is ok though). "Data source name not found and no default driver specified" What error are you getting For anyone interested: This was an issue with running the ODBC driver (presumably 32 bits) in 64bit mode. Running the package in 32 bit mode fixed the problem. A bit ...Show All

• mahima Another aggregation design question

  Guys, I model a cube with dimensions, I create the partitions and their aggregations, then I change the dimensions structure or I change the dataview. Cube does not complain about aggregations at any time during the change process. So what is this all about I suspect I should run a re-design of aggregations when I am done with structural changes but I wonder why I am never warned about existing aggregations becoming obsolete So when should you re-design aggregations (I use 30% then I add usage based after a while). Thanks, Philippe Yes, you need to go an re-desing your aggregations after you've made stuctural changes to your dimension: You've added, or removed attrubutes from the dim ...Show All

• Philippe Cand discarding rows - best practice?

  I have a need to filter out certain rows from my data stream. I cannot apply the filter against the source data using my DataReader component, due to some constraints in the source system. Therefore, I must filter the data out after it enters my datastream (trust me on this part). I have created a data flow that uses the Conditional Split transformation to do this. I created one condition that matches the rows I want to discard. I then connected the Default output stream to my target table. I have simply left the "discard" output disconnected. This appear to do what I want. My question is: is it OK to leave outputs disconnected in this fashion It isn't really apparent when viewing the package that the conditional split is ...Show All

• Ilya Margoulis Using same heirarchy on both Axis1 and where clause.

  Hi, I want to create a report on most used products. The query is filterable by set of users, for a selected date range. The requirement is that this report should also be filterable by product. The MDX query is as follows: WITH MEMBER [DATE].[Date Str].[DateRange] AS AGGREGATE ( STRTOMEMBER(@startDate) : STRTOMEMBER(@endDate), [Measures].CURRENTMEMBER ) MEMBER [USR].[USER NAME].[UserName] AS AGGREGATE ( {STRTOSET(@users)} ) MEMBER [PROD].[PRODUCT NAME].[ProdName] AS AGGREGATE ( {STRTOSET(@prodName)} ) SELECT NON EMPTY { [Measures].[PRODUCT Count] } ON COLUMNS, TopCount ( Filter ( {[PROD].[PRODUCT NAME].[PRODUCT NAME]}, [Measures].[PRODUCT Count] <> 0 ) , 10, [Measures].[PRODUCT Count] ) ON ROWS FROM [ProdUsage] WHERE (([USR ...Show All

• NerdyNick I can't get a SQL QUery to accept a null for a parameter

  I have straight forward Insert Query, which takes values mainly from text boxes, however I am having trouble when the value is null. eg cmdP0.Parameters[ "@EmpID" ].Value=txtEmpNo.Text; When I run the Query I get... Message="Parameterized Query '(@ID int,@EmpID int,@Photo nvarchar(260),@DoB smalldatetime,@Med' expects parameter @EmpID, which was not supplied." I also get this when the parameter can be a string. I have set the parameter properties so that SourceColumnNullMaping to true (it was set as false - so hoped this might fix it!) No luck. Int32 is a struct (a value type). That means it can't be null. .NET 2.0 adds so called Nullable Types. That means you can set an ...Show All

• spydude777 How do you continue the process after data viewer stops it

  Hi, These are couple of simple questions. When I set the data viewers and start the package, data viewer windows pop up but data download process stops. How do you resume the process Also if I press "hide" for a data viewer window it disappears. How can I get it shown again Thanks for your help Gulden wrote: Hi, These are couple of simple questions. When I set the data viewers and start the package, data viewer windows pop up but data download process stops. How do you resume the process Also if I press "hide" for a data viewer window it disappears. How can I get it shown again Thanks for your help Without sitting in front of SSIS, I can answer only your first que ...Show All

• Aaron.W "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 1627

  Hello, We are running Windows Server 2003 SP 1 and trying to upgrade SQL 2000 SP 4 to SQL 2005 using the command line. The process finishes in under ten minutes. Summary.txt file we have this information: Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup_<ServerName>_SQL.log Last Action : ValidateUpgrade Error String : The installer has encountered an unexpected error. The error code is 2259. Database: Table(s) Update failed Error Number : 2259 In the log file named SQLSetup_ServerName_Core.log I found the following: Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "C:\Program Files\Microsof ...Show All

• MunishGupta Can't create table definition with primary key and SMO.

  I'm trying this code, but it doesn't work. Can you help me I show you the error and code...I don't understand what is the adverted "Primary element" in error messaje and I'm really astonished because one time the code works whitout index definition, but any way, it doesn't work now. Thanks, Asereware Context Info: Visual C# Express Edition. SQL Server 2005 Express & SQL Server 2000. The behavior is the same in both. Error message: <ERROR>------------------------------------------- Fuente:Vivenda.Testings Descripcion simple: Error de Crear para Tabla 'dbo.AsereTablaSMO1'. Detalle: Microsoft.SqlServer.Management.Smo.FailedOperationException: Error de Crear para Tabla 'dbo.AsereTablaSMO1'. -- ...Show All

• Jay2801 Dynamic goal for a KPI?

  Hi! I'm new in SSAS and I'm stuck. Here's my problem : The goal of my KPI has to change (every month or every year). I could enter these different values with an MDX expression such as CASE WHEN <date condition> THEN goal-1-value ... END but i'd like it (different values of the goal) to be stored in a database. So my question is : Is it possible to get back these values from an MDX expression If not is there another way to get these values from database in SSAS Thanks in advance, Philippe Assuming that you do store the goal values in a table, you coud add a measure group, with a measure for the goal value, to the cube. Then this "goal" measure can be directly accessed in MDX. ...Show All

• Terrence Chan Error between string data types

  I reinstalled SQL Server, setup new connetions in my existing project and then pointed the existing controls in my SSIS packege to my new OLE DB Connection manager. When I run my package, now I get: TITLE: Package Validation Error ------------------------------ Package Validation Error ------------------------------ ADDITIONAL INFORMATION: Error at Data Flow Task 1 [OLE DB Source 1 [73]]: Column "TransactionDate" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task 1 [OLE DB Source 1 [73]]: Column "TransactionTime" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task 1 [OLE DB Source 1 [73]]: Column "AccountNumber" cannot convert between unicode ...Show All

• nobs411 Error - Cannot open the datafile

  Hi there, I have written a program that loads a package ( SomePackage.dtsx ) from the physical drive and executes that. The package does nothing but imports data from a csv file to the Sql server 2005 . But I can see that the package is failing continuously. I meant the package.Execute() method is returning a DTSExecResult . Failure . I investigated the Package.Errors property that contains the error collection and found that there are two DTSError objects into the collection. The first one’s description says that Cannot open the datafile "D:\SOME.csv". And the later one’s is component "SOURCE FLAT FILE COMPONENT" (1) failed the pre-execute phase and returned error cod ...Show All

• Angry Coder Can't connect to sql express 2005

  I have an very big application written in vb6 running on msde 2000. I tried to change it to sql express 2005 and I cannot connect to the database. I wrote a sample app in vb6 using adodc and it works fine. From the other app I get no connection. I copied the same connection string!. I do not use the adodc control.I connect with a connection object.I have enabled pipes and tcp/ip. Any ideas or suggestions more than welcome. There are many KB articles which walk through remote connections to SQL Express. Please check out the following: http://support.microsoft.com/kb/555585/en-us - in addition to enabling tcp connections, you need to ensure you have allowed remote connections and setup the firewall ...Show All

• Udo Kroon Unwanted datatype conversion with Named Queries on Oracle ds?

  I am working on SSAS05 with an Oracle ds., connected with Native OLE DB / MS OLE DB Provider for Oracle. The "normal" datatype of the table keys in the .dsv in the property window appears to be System.Int64. If I create a Named Query the datatype of the key of the Named Query table is automatically changed to System.Decimal. The effect of the change to Decimal is that now I cannot join the table with any other in the dsv because I get: "The my_source and the my_destination columns have different datatype" and the join is not made. A solution is to change ALL of the tables in my dsv in Named queries, which I do not want to do if poss. Is it a bug Can I change the datatype of Named Queries columns How ...Show All