JCJCJC's Q&A profile

• SQL Server Do you need to be a programmer to use SSIS?

  Hello I've been looking for SSIS examples where you need to import data from a OLE DB datasource and export it to a OLE DB destination source whilst the data in a colum is being transformed with a simple SQL statement. For example: SELECT ( CONVERT ( datetime , Left( Counterdatetime , 23 ))) datum FROM CounterData It seems to me that you have to use the Script Task Component ans start coding in Visual Basic.Net (or whatever) Am I missing something here or is it normal you have to be a programmer to do simple thins like that Many thanks! Worf wrote: Hello I've been looking for SSIS examples where you need to import data from a OLE DB datasource and export it to a OLE DB dest ...Show All

• .NET Development check SQL Server database/table size

  how can I check the SQL Server database & table size (in MB) using C# Have you looked at the sp_spaceused stored procedure Check it out: http://msdn2.microsoft.com/en-us/library/ms188776.aspx ...Show All

• .NET Development Empty String Being Passed

  I have a stored procedure that sends cdo mail, and the sp has a parameter that I can pass a semi-colon separated list to that specifies the attachments for the e-mail.....The e-mail has always worked for me, and when I pass it the attachment parameter from query analyzer it works fine, and it has always worked when the procedure is called via .NET. The problem is that recently I have .NET dll that I created that passes a long list of attachments to the sp, I tried the values from query analyzer and they worked but when I pass them from .NET the sp says the parameter value is blank. There are no errors, it just seems to be not accepting such a long parameter string even though the value is shorter than the parameter length (in both the sp a ...Show All

• Visual Studio Team System Not Ordinary MS Project mapping

  In my WI Task” I’ve added field name “Task Type” with two values: “Grouping field” and “Detailed field”. I wont to map this field to MS Project. It should change its value depending on the fact if in MS Project the task is a grouping task (have subtasks) or not. In other words. I Have two tasks – A and B. When I change in MS Project task B to a subtask of task A (A will become a grouping task) and send changes to TFS, then the field’s “Task Type” value for task A should change to “Grouping field”. Is there any possibility to achieve this effect Best, It can be achieved but it will need some coding from your end. 1. Has you are doing currently. Have a WI, Task with "TaskType" field, have a rule fo ...Show All

• SQL Server URGENT PLEASE HELP

  Hello i’ve a problem in sql but i cant fix it some on can help I’m runnig SQL Server 2000 SP4 with Windows 2003 Server with the hiper threding tecnology. The error is this: 2007-02-27 07:31:12.30 spid59 WARNING: Failed to reserve contiguous memory of Size= 65536. 2007-02-27 07:31:12.31 spid59 Buffer Distribution: Stolen=609 Free=911 Procedures=523 Inram=0 Dirty=63344 Kept=0 I/O=0, Latched=32, Other=47333 2007-02-27 07:31:12.31 spid59 Buffer Counts: Commited=112752 Target=113711 Hashed=110709 InternalReservation=122 ExternalReservation=2216 Min Free=128 Visible= 113711 2007-02-27 07:31:12.31 spid59 Procedure Cache: TotalProcs=251 TotalPages=523 InUsePages=291 2007-02-27 07:31:12.31 spid59 Dynamic Memory Mana ...Show All

• Visual Studio Team System Modifying StartDate

  I have a Team project set up using MSD for CMMI. I have downloaded and modified the project field mapping file as follows (The only changes I made are in red): <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.StartDate" ProjectField="pjTaskStart" PublishOnly=" false " /> <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.FinishDate" ProjectField="pjTaskFinish" PublishOnly=" false " /> I then uploaded the file successfully. But I still cannot modify the start and finish date in project and have it publish back to TFS. If I make a change to the start or finish date in project, I can successfully publish and then refresh ...Show All

• Visual Studio MSBee and toolsets

  Just as a reminder, the MSBee toolset (a set of tasks and targets that MSBuild can use to create binaries targeting .NET 1.1) has a forum of its own at http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=291&SiteID=1 For example I posted something to clarify what we consider a "toolset" and how we might improve our support for the concept going forward. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=510398&SiteID=1 Questions welcome there. Dan ...Show All

• Windows Forms Want to set initialdirectory to the mycomputer

  Hi All, I am using openfiledialog and savefiledialog in windows form. I want to set its initial directory to "my computer". I have tried Environment.GetFolderPath(Environment.SpecialFolder.MyComputer) but it's not working. Anybody please help me in this..... thanks for reply but I want to set initialdirectory............. i don't want to use win32 api's dialogbox. i have to use .net openfiledialog box............ Can anybody help me in this ...Show All

• SQL Server Trim off text during insert

  I know this is an easy one probably but still not sure what SQL function to use. How can I trime off everything after the sequence of chars with '<br><br><b>If you' The field: Product.ProductDesc(varchar(5000), not null) Example Text: Here is a sample for you to download.<br><br><b>If you would like to download, please click on the link below. So how do I trim and keep just 'Here is a sample for you to download' in a select statement Is this what you have in mind: declare @sampleVar varchar (2000) declare @sep varchar (20) set @sampleVar = 'Here is a sample for you to download.<br><br><b>If you would like to download, p ...Show All

• Visual C# Seems simple enough ... but how?

  I want to temporarily disable event handlers in my Winforms app. I have some code that I only want run when users are changing field values, not when code is setting them. Is there someway to say: DisableAllEventHandlers Some Code Re-enableAllEventHandlers Events are delegates and can be added and deleted in the code. For example the line below adds a MouseClick event to button1. So when you click the mouse on button1 button1_MouseClick method will be called button1.MouseClick += new System.Windows.Forms.MouseEventHandler( this.button1_MouseClick ); Line below deletes the event this.button1.MouseClick -= this.button1_MouseClick; Hope this helps. ...Show All

• SQL Server SQL Express won't install, seeing existing product key

  hello, WIN 2003 web edition. Purchased sql 2005 standard because express was dropping transactions due to too many connections. Installation failed, found out we couldn't install it on 2003 web edition. Am now trying to re-install express to get the store back online and it is failing, says it sees an existing product key and it is incorrect. I have uninstalled everything (about 100x's) and even there is nothing in the hkey_local machine\software\microsoft\windows\uninstall list of guids that has anything to do with sql server, but the install still won't work. PLEASE answer soon, I have definitely lost this client for good but I would like to get their site up asap. Thanks The easy ...Show All

• Visual C++ Starting off with C++

  I keep hearing it's hard to learn, but that you should try and begin learning with C++...That being said I just downloaded Visual C++ Express and was eager to code for the first time   Only to be even more frustrated; I created a new file under Visual C++, C++ file, then started typing in code from tutorials.  The color of the text is changing, appearing like I'm entering code but there is no output.  Here is what I typed // my first program in C++ #include <iostream> using namespace std; int main () { cout << "Hello World!" ; return 0; } Output doesn't appear and when I click on "Show output from" it makes a noise that I can't do it. Do I have to create a certain type of file or ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XBox 360 Controller + Windows 2003 Server?

  Hi, My day development job means I have Windows 2003 Server as my primary development machine. I have XNA, DX and all that working fine, Space Wars works great. I've not got an XBox 360 yet (saving up for Christmas / whenever XNA gets released so I can get my hobby games on the XBox) - but was going to buy a XBox 360 Wired Controller for now. I know there is no *official* support for such devices on the Windows 2003 box - but has anyone got the wired XBox 360 controller working on their Win2k3 box and nicely accessible by XNA Thanks, Paul I gave it a try. The 360 controller's driver installer gives an error about how only the only supported operating systems are Windows XP SP1 and SP2. Just for the hell ...Show All

• Smart Device Development COM port communication on emulator

  I have basically used this code (C#) http://msdn2.microsoft.com/en-us/library/system.io.ports.serialport.readtimeout.aspx taken here from MSDN to make a com port communicator. I have done the basic adjustments to the CF 2.0, and I have handled the com port mapping in the emulator configuration. Using a similar program for COM port communication from the PC works fine. But I can't communicate through the COM port when I use the emulator. After the initialisation I check if the port is open, for what it's worth, but I can see with a break out box on the RS232 pinning that no bytes are sent although I get no error messages. I would be grateful for comments and tips on tutorials or tips on this issue. Since the threading in the CF is reduced, ...Show All

• Architecture How can you model this without a circular reference?

  This might be in the wrong forum; sorry. I have a really tough data modeling problem, and I'm dumbfounded. I hope there's somebody with an idea. The problem really deals with aquatic habitat and vegetation, but I'll frame it in a more familiar context. It's a very common scenario. An employee works for a company. The employee is assigned to a project. --------- --------- -------- Company --> Project --> Client --------- --------- -------- | | | | ---------- ------------ Employee --> Consultant ---------- ------------ If you add this "consultant" relation between employee and project, isn't that a circular reference Doesn't that violate like 4th normal form or something Is ther ...Show All