Answer Questions

• KONJIRO Datamining for ntext

  Is there any way to datamine using ntext I'm trying to run some BI on some email messages -- seeing if it can accurately classify email into the proper folder. Currently, I get complains that ntext isn't comparable. Is this scenario supported It depends on what you really want to do. You can merge them using merge transforms in Integration Services to do term extraction. On the term lookup side, you can do the same. However, you may want to output the results of the different sets to different tables so you can seperate their inputs as input to a mining algorithm. For example, the phrase "Data Mining" in the subject may have different predictive power than "Data Mining" in the ...Show All

• Santor The error code is 2380. Error opening file for write: 5. GetLastError: SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup.

  I get the following error message when I install sqlserver 2005. TITLE: Microsoft SQL Server 2005 Setup ------------------------------ The installer has encountered an unexpected error. The error code is 2380. Error opening file for write: 5. GetLastError: SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup. For help, click: http://go.microsoft.com/fwlink LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=2380&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroup%40Do_sqlGroup%40x5 ------------------------------ BUTTONS: &Retry Cancel ------------------------------ Anybody got an idea Thanks does the directory have write permis ...Show All

• Bakerboy60 Save data flow task result into specific table in database

  Hello Kindly i need support in this issue, i create task flow import from flat file and store in database but i need to save all result for task into specific table   Like Record count transferred Destination t able name Time ..........etc thanks   where in the main page Sounds like you are looking for auditing information. Watch the Kimball Webcast on the main page of this forum. Plenty of examples in there. In summary, you'll populate variables in your data flow, and then after the data flow completes, you'll use an Execute SQL task in the control flow to perform an insert statement into your "specific table" using those variables previously populated. Hosam Abd EL-W ...Show All

• JavaBoy Do I have to rebuild all my aggs after a ProcessUpdate of my dimensions

  In this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=580892&SiteID=1 Edward told me that doing a ProcessUpdate of your dimensions causes the indexes and aggregations of all your partitions that use those dimensions to get dropped. I am really worried about this. Does this mean that I have to manually rebuild all my indexes and on ALL partitions after I have done the ProcessUpdate or is it done for me Another worry is that if I have a big fact table this could take a long long long time. In fact I'm not just worried, that is a huge risk in my book. Could soeone fill me in as to what happens with the indexes and aggs after they are dropped. Thanks Jamie This is known and well documented sit ...Show All

• Xancholy Complicated join question.

  Hi there. I'm running Microsoft Business Solutions GP 8 backed by SQL Server 2000. I need to write a little C#/.NET 2.0 app to go "behind the scenes" to the SQL server in order to fetch and alter some data. Unfortunately, the tables that GP 8 has created seem strange to me; I've encountered an issue with a SELECT clause featuring two INNER JOINs. I need to select columns from three different tables. Unfortunately, the key structure of these tables is strange at best. You may view the structure of the three tables from the following URL. http://pastebin.com/732226 My SQL query is as follows. SELECT IV30400.DOCNUMBR, IV30300.DOCDATE, IV30200.GLPOSTDT, IV30400.SERLTNUM, IV30400.ITEMNMBR, IV30400.SERLTQTY FROM IV ...Show All

• kirupa SQL 16-bit client tools install fails

  I get an error during the SQL 16-bit client that I grabbed from the SQL 6.5 CD and I'm installing onto a Windows 2000 SP4 Server. I choose TCPIP from the Network Protocol dropdown, that's the only option I change. First error pops up with the DSHELL in the title bar: An error has occurred in you application. If you choose Ignore, you should save your work in a new file. If you choose Close, you application will terminate. I click on Ignore and get the following error with Application Error in the title bar: DSHELL caused a General Protection Fault in module MSCUISTF.DLL at 0003:1FA2. Choose close. DSHELL will close. I saw one post on another forum regarding the same exact thing but on that board it went unanswered. ...Show All

• Julian Ladbury Data encyption using symmetric keys outside SQL Server

  Hello. I have a problem that spans VB.net, SQL Server and SSIS but is rooted in the need to encrypt column data in SQL Server. I would like to encrypt data that I am bringing into SQL Server in the Data transformation script component of an SSIS package. I have achieved this but I can't decrypt the data because the keys don't match. I would like to use symmetric key encryption but I don't see how to get the symmetric key that I created in SQL Server available to the VB.net script component in SSIS. Please advise me if my approach is correct and what steps I need to take. Here is a link that should be useful. In this link the author was also using ASYMMETRIC KEYS in SQL Server and VB .Net: ht ...Show All

• JohanNL SQL Server security confusion

  Hello, i'm quite confused from SQL Server 2005 security permission granting. Could you be so kind and post some generic, compact, web source for this topic, please Thank you. I hope these two links will have enough information to help you out: * Permissions: http://msdn2.microsoft.com/en-us/library/ms191291.aspx * Permissions Hierarchy: http://msdn2.microsoft.com/en-us/library/ms191465.aspx Please let us know if the information there is still not enough to answer your questions, we will be glad to help you and try to improve our documentation. -Raul Garcia SDE/T SQL Server Engine Thank you Raul for your kind help. This resource lo ...Show All

• JoachimLaursen Comm. between SQL Server data and Sybase SQL Anywhere Studio data

  Hey folks, we are bringing SQL server technology in company and want to build the DB in SQL SERVER which currently needs to talk to one of the application which basically uses "Sybase SQL Anywhere Studio"  as backend ,How this is possible   Anybody knows or looking for detail explaination/process.   ...Show All

• mukilan91 wmiprvse.exe

  Coincident with installing SQL Server 2005 Express, i.e., correlation only (for now), I have been getting a dialog indicating an application error with wmiprvse.exe . I cannot find any cause and effect. This is on a XP-Home OS which also has VC++ 2005 Express on it. Anyone have a similar experience Thanks. Thomas I did look at the suggested links and it is going to take me a while to work through them. Thanks for the recommendations. The following is speculation on my part, so consider it FWIW. A Windows update (this is an XP-Home with SP2) about 10 days ago tried to install KB923980. It keeps trying to install that. Further, after I have gotten the message th ...Show All

• hazz filtering calendar control?

  Hello, Please, help with following issues. I have 3 parameters in the report. When user selects 1st one from dataset, one of the fields gives me object creation date. Calendar control is supposed to be filtered to allow users select the dates greater than selected one. How can I filter (disable dates in) calendar control Any suggestion/comment highly appreciated Not sure if that is possible without writing a custom front end. cheers, Andrew Is it possible to do in the report's code To put it other way, how to get access to calendar control object from the report's code Thank you ...Show All

• Lawrence 007 SSIS Package Configuration Filter

  We have more than 100 packages which referenced many of the same data sources. In ideal situation, we would like to create three master filters based on the dev, test, and prod servers and all packages can just reference the same filters. However since one package normally only use a subset of master connections defined in the configuration files, if only those subset of connections are set up in the package, when the package is first open in BIDS, lots of errors will pop up saying that it could not find the connections defined in the configuration files. Even though this will not cost runtime error, it is still very annoying. Does anyone have better ideas on how to handle this Jamie, Thanks for your ...Show All

• Alex-MyRpg Importing data using import service/DTS

  Hi, I'm using Sql server 2005 and I need to import about 15000 records from a txt file which is delimated using " | " character. Part of the problem is that the file has about 109 fields. The other part of the problem is that there aren't any headers defined. The field name and their respective data types are defined in a sepearte excel sheet. When I'm trying to import it using Sql Server 2005 import wizard, I would have to modify the names and the length manually and change the data types which is a time consuming job. My boss has claimed that he did it in Sql Server 2000 without using BCP utility and he got the table columns from the excel file (he didn't have to modify it manually somehow he import it) but he can't really remember !! ...Show All

• yosonu cannot copy sqlexpress to another pc for vb.net 2.0 project update

  Hi. I have done alot of searching around but can't find answer to this specific problem. Here is my connection string in vb.net app config <connectionStrings> <add name="myfile.My.MySettings.ffgscrmConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\myfile.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings> The database is locally attached to the vb.net project residing in a data directory in the project. I am testing installation on a virtual pc - with no sql express managment or other sql server databases attached. When I do a vb.net setup project and run this ...Show All

• Rei Shapira Having a problem sending a query ?

  I wanna search for cars thats are Ferrari,_NAME and _TYPE fields are full text indexed SELECT COUNT (*) FROM CONTAINSTABLE ( ADDS ,*, 'Ferrari AND Cars' ) >>> return only 8 results but in facts there are 600 results.Doesn't "*" search in all coloumns ******************************** Do I have to make a query like this.... SELECT Count(T1 . [KEY]) FROM CONTAINSTABLE ( ADDS , _NAME , 'Ferrari' ) AS T1>>>>>return 600 results. INNER JOIN CONTAINSTABLE ( ADDS , _TYPE , 'Cars' ) AS T2 ON T1 . [KEY] = T2 . [KEY] I don't want this type of query as I don't know how many parameters I will have and I am sick of the joins which slow down the server. moving t ...Show All