Answer Questions

• QWERTYtech Problem using openrowset to query foxpro VFP 9 tables

  Hi, I have been trying to query VFP Foxpro table using following command. Select * from OpenRowSet ( 'VFPOLEDB' , 'C:\ShareBridge\Dbf\WLK\Dbf\' ; '' ; '' , 'SELECT * FROM SOM.DBF' ) as A I have upgraded latest oledb driver for visual FoxPro 9 but, all the time it gives me following error message. /************************************************************** Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "VFPOLEDB" for linked server "(null)" reported an error. Access denied. Msg 7350, Level 16, State 2, Line 1 Cannot get the column information from OLE DB provider "VFPOLEDB" for linked server "(null)". ************************************************/ ...Show All

• Daniel Coleman Proxy Class is fine when used in C# project but returns error when Used with SSIS

  My proxy class returns web service responses well if I use it in a C# code.  I compile it with CSC and put it in GAC to use it with SSIS. Then I get web service response with some field values populated with "Exception of type :{System.InvalidOperationException "' occured. Here is the part of web service response received by the C# program: Name Value Type mainAddress {Address} Address city Metuchen string cityField Metuchen string country USA Country countryField USA Country state NEW_JERSEY State stateField NEW_JERSEY State Here is the same objec ...Show All

• JonEagle Dynamically execute a string as an expression

  Hi, Is it possible to execute a string which is entered in the value of a texbox. For example: I have a table with 4 groups. The detail row of the table is filled with a dynamic query like: ="SELECT FactSales.CustomerNr, " & Parameters!SalesFigure.Value & " AS SelectedFigure FROM DWHSales". The "SelectedFigure" comes from a Parameter Combobox. Because the SelectedFigure could not allways be sumed (sometimes I have to do some special math's), i will put in the group header rows a string like =Code.GenerateSumString(......) which returns a string like "Sum(Fields!Fieldx.Value)" and this string should be executed, Is there a mechanism like =Execute(Code.GenerateSumString(...)) available ...Show All

• sofakng Missing table in Datasource View dropdownlist of ProcessAdd config form of AS Process Task of SSIS

  I made 12 facttables and set them to the 12 partitions. the 12 facttables are the same, and I only build measures on facttable11. My first question is , will this be ok You know, when you build a measure group, it ask you to chose a facttable. I could not chose all the 12 facttables, right I only need to chose ANY one of the 12 tables,right If the answer is YES, could I chose diffrent tables for diffrent measure group and get the same result Nothing mentioned in MSDN. My second quesiton is, when I drop an AS Process TASK in SSIS, and chose to do a ProcessAdd on a partition, on the config form it ask me to chose a table or view that point to the partition i need to Process. On the Datasource View dropdownlist, If I chose the Datasou ...Show All

• AdeptBlue Update query runs very slow in SQL 2005 than SQL 2000

  We have upgraded our database server from SQL 2000 to SQL 2005. To migrate the DB I attached the mdf file in SQL 2005. After migration website loads quicker than earlier but records updation ( no of records are 20k) got slowdown. I have found that update query run very slow in SQL 2005 as compared to SQL 2000. Although other select query run very faster. Query is called from ASP (active server page) page. Changing of fill factor option from 0 to 70 also did not work. I also have set the competible leve to 90. OLD Sever Config: dual xeon 1GHz, 512MB RAM, window 2000, MS SQL 2000 New server Config: Dual Core Xeon with 2 CPU, 10 GB RAM, window 2003, MS SQL 2005 size of mdf file is 16GB Rebuilting of index did not improved the p ...Show All

• byronfromwesleyan Merge Join vs. Lookup vs. Custom Script - which is fastest?

  Very often we have 50'000+ rows which you need to pull values from different source (e.g. CityNames from citycode in Excel file). Currently we are using Lookup - but the questions is which of those 3 options is best in performance wise Do a fair comparison though. Either change your query to cache the rows from SQL or disable caching on the lookup. Oranges != Apples. A non cached lookup will be expremely slow as was your script component. Thanks guys for your answers - I will try it out performance testing this weekend on my free time. So far it has seemed to me merge join is slower than lookup, however, lookup seems to take much longer than i like it to - so i was wondering if creating a script transform would be ...Show All

• vsnetdeveloper How do you hide items in the Report Explorer Web Part?

  Does anyone know if it is possible to hide a report in the report explorer web part in sharepoint. I have a report that can't be run by itself. It can only be run when you click on a detail line from another report. Thanks. The items are only hid while in the list view, not while in the detail view. Hmm, it should hide them in the SharePoint view as well. A quick test here hid the elements. Can you look to see what the url is on the iframe on the WSS page. It should have something like ViewMode=WebPartList in the url. Can you confirm that it does Yes that option hides items in the list view but not in the detail view. But it only does this in the report manager page. We are using the Repo ...Show All

• Tamim Sadikali rsAccessDenied

  I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error: The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied) Here is my code: Dim u As New UriTypeConverter Dim ReportParameters(0) As ReportParameter ReportParameters(0) = New ReportParameter("ProjectKey", 262) rv.ShowParameterPrompts = False rv.ServerReport.ReportServerUrl = u.ConvertFromString(" http://localhost/ReportServer/ ") rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report" rv.ServerReport.SetParameters(ReportParameters) It looks like Networ ...Show All

• Selva kumar Events keep bubbling up, even with Propagate=False

  I've been pulling my hair out for the last couple of weeks trying to make my SSIS package more robust. I'm running SQL 05 SP1 on Windows XP SP2. Right now when there's a failure, the error propagates all the way up and my package stops running. Clearly not very robust. I have a heartbeat portion that makes a connection to the database every couple of minutes. Sometimes it loses the connection in the middle of the night, probably due to some maintenance going on. I have created an event handler to log the error, sleep a couple of minutes and set Propagate=False. This works great. When the connection is down, the error is logged, once the connection comes back, the package just keeps going. I also have an FTP component that receives a file a ...Show All

• Blair Allen Stark Iterating the rows of a script component

  Hi There, Can someone please let me know what is the best way to iterate the output rows of a script component and stick in those ids in a where clause of a select query (to retrieve additional info from a database) Is this possible at all If not, what is the best way to deal with this situation Thanks a lot!! Sam_res03 wrote: Jamie, Thanks a lot for your reply. I think I am almost there...So I have one one column in the recordset. Is this what I should do By using a for each loop container, with foreach ado enumerator I can get the id and store in a variable. Next can I have a dataflow task in the foreach loop... and in that dataflow task, can I access this id pass it as a variable to an sql command (in ...Show All

• David-Paris Not able to insert record in SQL server 2005 Express Edition

  Hello, In a web application of VS.Net 2005 I am able to insert records in both the database SQL 2000 & 2005 In a windows application of VS.Net 2005 I am able to insert record in SQl 2000 but I am not able to insert record in SQL 2005 Express Edition. Please help Me I tried very Much but not succeded yet. Thanks in Advance To answer your question will require one of two things: 1. Extra sensory perception, or ESP. 2. More information about what the error you are getting. Not to mention if the web app is using the same code, or different code and if it is using the same SQL Server 2005. My guess is that if the web app is using a default instance of 2005, you might not be connecting ...Show All

• jojo82 splitting data

  I've read that we need to split data into a training and testing data set. How do I go about that Microsoft Neural Networks and Microsoft Logistic Regression will pick a random sample of the data. The size of the sample is determined by the value of the HOLDOUT_PERCENTAGE parameter, which is, by default, 30% of the training set. Great! Thanks! Any documentation on how the algorithms choose the training and validation cases I understand how to split the data in SSIS, but how do I tell the DM tool, using a tree algorithm, that one table is training data and the other is testing/validation data You don't need to - any internal validation done by the algorithm is opaque to the user based on the dataset that you provi ...Show All

• Mitch Wardrop Reporting services configuration Killed several Summary Report functions

  I installed 2K5 developer on my box. I was impressed with the Summary tab report functions and the reports available there. Then I ran the "Reporting services configuration" tool to get RS running, but now several of the summary reports are broken. There are several different error messages given in the summary window, depending on the report selected. For example, the "server dashboard" now displays Summary Unavailable The information needed to display a summary page for the selected object is not available. Error: "sql_handle" is ...Show All

• aliasx Login without Connect Permission somehow managed to become db_owner!?

  I tried asking the same question in other forum but couldn't get an answer. I used exactly the following SQL to create a login with sa account in SQL2k5 Management Studio: Create Login yy With Password='yy123Z' Without granting any permission, straight away, i log out sa and login as yy in management studio, yy somehow can access one of my ApplicationDatabase! So i check with the following SQL in my ApplicationDatabase: IS_MEMBER('db_owner') and it returns me 1, meaning yy is db_owner. I then quickly login as sa and double check on the security|login|yy|properties|User Mapping, NONE of the database is mapped! and i also ensure "Guest account enabled for: ApplicationDatabase" is unchecked. What could be the problem i am facing ...Show All

• BuNnY_MoOn Increase # of chars Query Editor when looking at large varchar field

  How can I increase the # of chars so that when I copy a varchar(5500) field from Query Editor back into my Query pane, it displays all the characters, and doesn't cut it off That is a limitation of the query windows.You will have to navigate through the menu Tools > Options > Query results > Result to text > Maximum numbers of characters displayed in one rows (<- increase this here) HTH, Jens K. Suessmeyer. --- http://www.wsqlserver2005.de --- Thank you, I know I increased that, but was looking at a record which only had a short length of chars to begin with so I wasn't seeing that the increase was actually working but good to know I was in the right place at least. Thanks! ...Show All