toforo's Q&A profile
SQL Server Package Runs in 1 minutes in Visual Studio but takes 5+ (sometimes hanges) as Job
I have an SSIS package that when run from Visual Studio takes 1 minute or less to complete. When I schedule this package to run as a SQL Server job it takes 5+ and sometimes hangs complaining about buffers. The server is a 4 way 3ghz Xeon (dual core) with 8GB ram and this was the only package running. When I look in the log I see that the package is running and processing data, although very very very very very slowly. Has anyone else experienced this Thanks for your help Marcus You need to identify what the differences are between the two executions. It could be network latency, utilisation of the box by other processes, the user that you're running it as....anything. What happens when ...Show All
Visual Studio Team System how to resove the problem "AbstractTypesShouldNotHaveConstructors" in FxCop
Hi, FxCop shows error " ComVisibleTypeBaseTypesShouldBeComVisible ". How could this be resolved. Thanks in advance. Hi, I receive the error " SpecifyIFormatProvider " in my project when i scan it with FxCop, how can it be rectified. Thanks in advance. ...Show All
Visual Studio Team System Error while following Naren's Blog for "How to use Custom Controls in Work Item Form".
I am using Naren's Blog for " How to use Custom Controls in Work Item Form". I am using SP1 & Microsoft.TeamFoundation.WorkItemTracking.Controls.dll with version 8.0.50727.127. I copied WorkItemIdReference.wicc and WitCustomControlSample.dll to C:\Documents and Settings\All Users\Application Data\Microsoft\TeamFoundation\WorkItemTracking\CustomControls I added <FIELD name="DuplicateId" refname="MyFields.DuplicateId" type="Integer" /> under <FIELDS> tag and <Control FieldName="MyFields.DuplicateId" Type="WorkItemIdReference" Label="&Duplicate Id:" LabelPosition="Left" /> in the FORM to Customize Bug Work Item. I am getting following error when I am trying to customize ...Show All
SQL Server MDX's ORDER Function
Hi I'm trying to order rows returned by a MDX query using ORDER function. It seems that I don't use it properly. Here is the query from the sample AS Database, AdventureWork. WITH MEMBER [Measures].DIFF AS '([Customer].[Country].CURRENTMEMBER, [Measures].[Internet Sales Amount]) - ([Customer].[Country].&[Australia], [Measures].[Internet Sales Amount])' SELECT [Measures].DIFF ON COLUMNS, ORDER([Customer].[Country].MEMBERS, [Measures].DIFF, BDESC) ON ROWS FROM [Adventure Works] what it returns is: All Customers $20,297,676.64 United States $328,788.93 Australia $0.00 United Kingdom ($5,669,288.37) Germany ($6,166,688.25) France ($6,416,982.87) Canada ($7,083,155.72) I expected to see "Australia" at the end of ...Show All
Visual Basic help property for menu items
Hi all, i have created a sample application in vb.net.i have menu strip in my form and added some menu items in it.when i bring the help cursor above menu items the cursor change as normal cursor.so i am not able to show the help topic for the menu items.is there any way to show the help topics for menu items Thanks, Ganesh ...Show All
.NET Development The status of a running process
Does anyone know of a way to determine if a process running on the local machine is hung, or not responding I'd prefer to do this in C#, anyone "Hung" is a relative term, the process could just be busy in a loop. If you are looking for something similar to what Windows XP does when it displays "Not Responding" in the title bar, try using the WaitForInputIdle() API function. ...Show All
.NET Development Web Service without IIS?
Hi all, I'm relatively new to programming so i could use some pointers here.I'd like to gather some input for a decision that's coming up for us. Im building a tool to create models with lots of objects in trees with logic etc. to do forecasting. Right now, i run the models by instanciating them from the client app directly, wich is fine for developement, but lateron this will have to be a serverside process, and multiple clients will have to communicate with it. All the knowledge we have in the firm about client server design is with com+, so they're not really helping. (they're only bashing C# every day, saying it's too much like VB) One 'trendy' way to do this would be to use XML/ Web Services to do that. That way i could ...Show All
SQL Server Can't Install Express because .Net Framework 2 is installed! I'm going around in circles.
I'm new to SQL Express and from the SQL Express DOWNLOAD page you need to install .NET Framework 2 then install SQL Express. After installing .NET Framework 2.0 I then attempt to install SQL Express and I get a message that SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework or SQL Server 2005. I used the Visual Studio removal tool and it took out .NET Framwork. I re-installed this and did a reboot and get the SAME ISSUE! CAN ANYONE GET ME OUT OF THIS MS loop nightmare. Thanks! Jeff This issue has been answered several times in this forum. Check out my answer to this post for example. Mike ...Show All
Windows Forms DataAdapter.Fill freezing app when using typed dataset
Hello! I’m pretty new to visual basic, and very new to .net altogether. However, I’m trying to read a text-file into a dataset, to later be able to update a SQL database. I’m using a background thread to do the dataadapter.fill, and following the progress with a timer updating a progressbar in the main UI. Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim ConnectionString As String ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & "C:\" & ";" & _ "Extended Properties=""Text;HDR=NO;""" Try Dim TextConnection As New Sys ...Show All
Visual C# Bug 2007?
first of all happy 2007 everyone :) I don't know why but when I use the following line: [assembly: AssemblyVersion ( "1.0.070101.00" )] I get the following messages: Warning 1 Assembly generation -- The version '1.0.070101.00' specified for the 'file version' is not in the normal 'major.minor.build.revision' format RepApp Error 2 Error emitting 'System.Reflection.AssemblyVersionAttribute' attribute -- 'The version specified '1.0.070101.00' is invalid' C:\Rep\RepApp\Properties\AssemblyInfo.cs 32 12 RepApp if I change the "7" to "6" everything is OK. Hi, version parts are stored as 16-bit numbers so values between 0 and 65535 are valid. So 060101 will be stored as 60101, 070701 is ...Show All
Visual Studio Team System Why there're always errors on "Reports" and "Documents"
Team Explorer shows four directories in a single project: "Work Items", "Documents", "Reports" and "Team Builds". But there're always red cross on "Documents" and "Reports", even I've set the user as an Administrator. Many thanks! From the client machine that's failing, you may want to try loading up the WSS and Reporting URL's in IE to see how that goes ( http://server/ and http://server/Reports/ ) Hopefully that will give some insight into what's going on (bad proxy, network problem to that machine, credentials, etc.) ...Show All
.NET Development PageBreak Issue
Hi, I am trying to create an excel xml using xslt and am having an issue with adding certain xml input components after the pagebreak. As an e.g ..here is my input file : <ROWSET> <ROW> <SECURITY_NAME>AUD/USD 07/19/2006 DEUTB-L</SECURITY_NAME> <TRANSACTION_TYPE>BUY FORWARDS</TRANSACTION_TYPE> <TRADE_DATE>06/14</TRADE_DATE> <SHARES>92400</SHARES> <COST>69348.97</COST> <PROCEEDS>68063.23</PROCEEDS> <GAIN_LOSS>-1285.74</GAIN_LOSS> <GPS_TXN_ID_CODE>200606150E1P0001</GPS_TXN_ID_CODE> <REPORT_NAME>CHCLM</REPORT_NAME> <ACCOUNT_CODE>250</ACCOUNT_CODE> <ACCOUNT_NAME>STRATEGIC GLOBAL FUND: P ...Show All
.NET Development Unique name for the validation report
Hi, I have developed a tool for generating a validation report. The tool reads off huge volume of data and checks for invalid data(records). Any invalid record found is spitted out into a report. Right now, the tool is designed in such a way that each time the tool is run, the same report (say validation_report.txt) gets overwritten with a different set of invalid records. My question is: How can I create a report with a unique file name everytime the tool is run..(like validation_report_1.txt, validation_report_2.txt..etc) I was looking at threads as an option..where each thread would generate a different report. Would that make it too complicated is there a simpler way of doing it Thanks ...Show All
Windows Forms Progress Bar
Hello, I want to add a progress bar to my application. I want the progress bar to run when the program is busy - so I created a timer that adds a value to the progress bar every second. My problem is that when I start the timer the timer code is not called because the thread is busy doing other things.. what can I do Thanks. I'll explain more. Currently the "work" is done in the UI thread, and that's why it is busy and I can't set a timer to advance the progress bar. I also can't start a background worker thread because its work is to update the UI (which is busy) So I guess that every time I have to do a long operation - if I want to advance the progress bar then I need to do the work in another thread, and start the ...Show All
Windows Forms Little help with DataGridView please
I have a dataGridView and an arrayList. I bind the arrayList to my DataGridView with: dataGridView.DataSource = arrayList; dataGridViewMessages.Refresh(); And my dataGridView displays correctly. Later in my code i wish to clear my dataGridView, so i go: arrayList.Clear(); dataGridView.Refresh(); but it reports an error. Whats the correct way to clear my DataGridView Later I wish to fill my datGridView again. Thanks. Paul. I've been trying this for a while now, and here's what i got: It seems that when you detach the DataSource property, all columns and column styles are cleared, so to repopulate, you will have to recreate the DataGridView control's st ...Show All