Lweek's Q&A profile

• SQL Server New to SSIS

  Hi All, I am attempting to create an Intergration Services package. I need to insert data into several from one table. Is it possible to accomplish this in one task Are there any examples anywhere Thanks for your help, Roy Have a look at the multicast transform. This allows you to create n copies of the same upstream data to do with as you please. Allan Wiki.sqlis.com "RoyAF@discussions.microsoft. ...Show All

• Visual Studio Team System Project Creation Problem: Unable to connect to the Windows SharePoint Services

  After installing TFS Beta 3, everything seems ok. Can connect to it, manage it, etc. However I cannot create projects sucessfully. When I try to I get this (excerpt from log): Event Description: TF30162: Task "SharePointPortal" from Group "Portal" failed Exception Type: Microsoft.TeamFoundation.Client.PcwException Exception Message: Unable to connect to the Windows SharePoint Services at TEAMSYS1 Exception Details: The Project Creation Wizard w ...Show All

• SQL Server URGENT: PARAMETER ISSUES WITH SQL TASK

  I have read all the post about passing parameters from sql task in and out and have tried them all with no anvile. Frist of, they are too many types to deal with now, db types, SSIS types. Why the hausl. Can we make data type flow a bit more easy. Well, enough about the complain. I have been trying to dynamically set my sql query statement for my datasouce component using a variable set by a sql task. The tried a couple of methods. Method 1 Usin ...Show All

• Visual Basic Save\Load values as text file

  Hello In VB6, I was able to save and load values as text file, it saves them like this form: "V1","V2","V3" I was using this code: Dim A As String, B As String, Op Op = FreeFile A = "Value1": B = "Value2" Open "D:\File.txt" For Output As Op Write #Op, A, B Close Op How can I do it in VB2005 Thanks & Regards The following code ...Show All

• Windows Forms Flashing Cell

  Hello, I have been writting quite some applications using .NET 2.0 beta. Once feature I would like to see when using DataGridView is an easy way to flash cells when they have been updated. This is very common in Financial applications. A method such as E ...Show All

• Visual C# Checking if a specific handler exists

  I was wondering if there was a simple way that I can check to see if a specific handler exists for a control. I know I can simply create and set a boolean variable to true once I create the handler, but I was hoping that there was a simple way, without the use of additional variables, to check whether or not the handler has been created: My control is a TreeView, and is called tvRobot. I create the BeforeSelect handler, tvRobot_Always ...Show All

• Visual Studio Team System Office Integration Error

  I've sucessfully installed VSTS Beta 3 Refresh following the single server instructions. I have also installed a seperate build server. Everything is working fine except the Office Integration. With MS Project files I'm getting: TF80071: Team Foundation encountered an error while accessing the work item database. Please contact the Team Foundation Server administrator. With MS Excel files I'm getting (replace projectname with actual project n ...Show All

• Visual Studio Team System Web Test against Classic ASP using Windows Authentication

  I'm new at the testing game so forgive me if this is a simple question.  I've got a classic ASP Enterprise level app, I need to set up a test that will run against it.  However it resides on a separate domain and uses Windows Authentication for entry.  How do I add a WA domain\username and password to the test script so I can logon and continue to test the app You can set a username and password ...Show All

• .NET Development How do i implement CustomCollection

  How do i implement CustomCollection I have Custom object Called Customer public class Customer { private string name = string.Empty; private string age = string.Empty; public string Name { get{return name;} set{name = value;} } public string Age { get{return age;} set{age = value;} } public Customer() { } } i wanted to implement collection of Customers. I know i can implement it using CollectionBase class like below public ...Show All

• .NET Development Controlling Garbage Collection?

  We have a .Net windows service running on a Windows 2003 64-bit machine whose main purpose is to cache Gigabytes worth of data and make that data available via remoting calls. Currently, the process uses 13.6 gigabytes worth of memory, storing data in three main Hashtables. The problem we're experiencing involves garbage collection. At 13.6 GB, the garbage collector seems to run about every two minutes, halting program execution for 30 seconds ...Show All

• SQL Server SQL Server 2005 Standard Installation Problem

  Hi, can anyone please help me.  I am having trouble installing SQL Server 2005 Standard or SQL Server 2005 Express.  Everything installs until it gets to Installing SQL Server Database Services, every time I get the following error - "The SQL Server Service failed to start.  For more information, see the SQL Server Books Online topics, "How to view: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."" i ...Show All

• .NET Development OTP: ATHLON 64 PROBLEM WITH WIN XP PRO

  IM RUNNING AN ATHLON 64 X2 ON WIN XP PRO, THE PROBLEM IM HAVING IS THAT WHEN EITHER I'VE BEEN RUNNING THE COMP FOR A WHILE OR MAYBE JUST STARTED IT RIGHT UP, MY MONITORS END UP FLICKERING ON AND OFF WHICH MAKES IT HARDER FOR ME TO DO MY WORK, I THOUGHT MAYBE IT WAS A POWER SUPPLY PROBLEM SINCE I WAS UNDERPOWERED, REPLACED THAT AND THE PROBLEM STILL EXISTS... DOES ANYONE HAVE A SIMILAR PROBLEM AS THIS OR HAVE A SOLUTION ...Show All

• Visual Studio 2008 (Pre-release) Publish Subscribe but with a bit of reliability

  I have a service, which publishes data. It could have many subscribers. 10s not 100s I want to loosley couple the service from its clients. I.e. I don't want to impliment a client proxy for each client subscriber in the service. I'd like the publishing service to define the contract. Duplex looks good for this scenario. I've looked at the looked at the publish subscribe example in the SDK and this looks good. However, the clients may ...Show All

• Visual Studio Tools for Office VSTO 2005- Word : Intercepting hyperlink events

  Hi, We are working in VSTO 2005, Word Project. Generally it is an XML Editor wherein which we will be allowing users to present their contents in the XML Tags. We need to facilitate one of the XMLTag content is to be shown as hyperlink and if the user clicks on the link we need to fire a Windows form to allow the user to enter additional details. As i explored in the Web (google) , i was not able to find the information about to intercept an hyp ...Show All

• SQL Server Reporting Services 2005 - Problems displaying a report via a ReportViewer control.

  I have a report that displays fine in VS 2005 (in the Preview tab), and if I hit it via a URL in IE as a deployed report. However, when I embed it in a ReportViewer control for display on a web site, I get no data back for the report. I am using an Oracle database for the data source. None of the the logs in reporting services show anything wrong, there are no events in the event viewer to indicate any problems, Oracle logs also show no problems ...Show All