Kurosh's Q&A profile

• SQL Server SSIS and Parent-Child relationship tables

  Supose I have two records in a parent-child relationsuip (actually I have many more such records). Does SSIS offer any support\task for inserting one record into the parent table, the other into the child table, and updating the foreign key of the child to point to the parent TIA, Barkingdog P.S. I have to do just this as part of the datawarehouse test I'm running. Seems like a common task but I don't recall anything in SSIS addressing the issue. This: http://blogs.conchango.com/jamiethomson/archive/2006/05/22/3974.aspx seems pretty similar to your scenario and should help quite a b ...Show All

• SQL Server SQL Server Backups - Help please

  Hi, Sorry, If I have chosen the wrong forum could someone point me in the right direction. I am new to SQL Server 2005 (in fact also to Visual Studio 2005...). I am trying to find how I can simply create backup(s) - daily if possible of the new database I have created. I would also like to create a script of all the tables I have so far created including indexes etc... to be able to recover from any failure and or transfer data to another database instance. Thanks in advance Andrew Mercer Hi, Found out how having realised that the initial installation of MS SQL Server 2005 had failed to install some packages - all ...Show All

• .NET Development Bug in VS2005 Custom Tool (XSDs) or VS2003 conversion problem

  I'm trying to convert an application from VS2003 to VS2005. My latest problem involves xsd files (dataset specifications). None of my VS2003 xsd files compiles within 2005. I get a similar error for each: Error 2 Custom tool error: Value cannot be null. Parameter name: ServiceProvider C:\Documents and Settings\user\My Documents\Visual Studio 2005\Projects\EDS C2 R13d (Perf fix DM)\PCIU_Projects\Main\SupportingData.xsd 1 1  Not very helpful. We used to be able to go to the xsd designer and remove and recreate the dataset but I don't see how this is done now and I don't know if it would even help. Any ideas ...Show All

• Visual Studio Express Editions How do you create a telnet interface using VB 2005 express

  I have read about the options of using (TestIPEndPoint, TcpListener, TcpServer, TcpClient, BufferedStream and GetStream). I don't know hope to get started. Like those who used procomm plus, or a telnet window program. Expect without the entire features. I believe for what I have read is: 1) TestIPEndPoint =tell it to build communication like the ip address and port 2) TcpListener =will be listening to the receiving data 3) TcpServer=is like the collector of data 4 ) BufferedStream and GetStream =our the bin to storage info/data I get a lot of build errors when I run the app, so I try deleting ...Show All

• Visual Basic PRINTING TO CONSOLE

  I AM TRYING TO USE THE CONSOLE.WRITELINE FUNCTION USING VB 2005 EXPRESS. I WANT TO DISPLAY 2 OR MORE VARIABLES ON A SINGLE LINE . I WOULD LIKE TO BE ABLE TO CONTROL THE SPACING BETWEEN THE VARIABLES. IF THIS CAN BE DONE WITH THIS FUNCITION WHAT IS THE CORRECT SYNTAX.  I HAVE ONLY SEEN SINGLE VARIABLES USED IN DOCUMENTATION. Console.WriteLine supports the same syntax as String.Format, so you can write: Console.WriteLine("Var1 = {0,20} Var2 = {1,30}", var1, var2)   The values of the variables will be inserted at the specified positions ({0}, {1} and so on), while the (optional) number after the comma defines how many col ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Moving character against moving world

  Hello, I'm building my first D3D game, a clone of Lander (the user must land off on a specific portion of ground with a maximum speed set instead of crashing) I'm wondering what is the best way : 1. Make the land module center of the world, camera looking at it and moving the ground mesh 2. lock the position of the ground and move both land module and camera accoring the user input. What are pros and cons about these two manners What about other games I'll build a day Thanks in advance. Steve Well, it's not just about the camera viewpoint, it's about the overall gameplay experience. Frankly, if you're just s ...Show All

• .NET Development hwo to set to avoid the SecurityException ...?

  ************** Exception Text ************** System.Security.SecurityException: Request for the permission of type System.Windows.Forms.SafeNativeMethods.IFont.GetHFont()    at System.Windows.Forms.Control.ActiveXImpl.get_AmbientFont()    at System.Windows.Forms.Control.get_Font()    at System.Windows.Forms.Control.GetParentFont()    at System.Windows.Forms.Control.get_Font()    at System.Windows.Forms.ButtonInternal.ButtonBaseAdapter.CommonLayout() ******************************** I'v used ".NET Framework 2.0 Configuration" tool, new a Permission set and set permisson "User Interface" "Grant ...Show All

• Microsoft ISV Community Center Forums Failure during install MS Score Card Manager

  During the install, I get: Failed Microsoft OLE DB Provider for OLAP Services (MSOLAP) 2000 SP4 (8.00.2039) Failed Microsoft ADOMD.NET 8.0 Can't seem to find the downloads or any other content addressing these failures. One effort pointed to Pivot Table services which I installed to no avail. Thanks for helping! ncjks You can find ADOMD.NET 8.0 here: http://www.microsoft.com/downloads/details.aspx FamilyID=790d631b-bff9-4f4a-b648-e9209e6ac8ad&DisplayLang=en The OLD DB provider for OLAP Services should be here (SP4 for Analysis Services) http://www.microsoft.com/downloads/details.aspx Fam ...Show All

• SQL Server How to sort table in sql2000 with ipaddress(format x.x.x.x) as column with nvarchar datatype in ascending order

  How to sort table in sql2000 with ipaddress(format x.x.x.x) as column with nvarchar datatype in ascending order without using stored procedure Ex: Table: netComputers(3 rows) Column Name: ipAddress (string data type) ipAddress 0.0.18.1 0.1.1.2 0.0.0.1 Sql query : if I use the query Select ipAddress from netComputers order by cast( replace(ipaddress,'.','') as numeric(12)) asc Gives result as : ipAddress 0.0.0.1 0.1.1.2 0.0.18.1 Where as expected result should be: ipAddress 0.0.0.1 0.0.18.1 ...Show All

• SQL Server New Guy Question: Which came first ... the chicken or the checkpoint file?

  Hello all...here's a question from a newbie ... I'm attempting to configure my SSIS package to use a checkpoint file.  I've checked the docs, and I believe I've set all the package properties for this ... except they are looking for the name of the checkpoint file.  I've tried a couple of experiments such as c:\myCheckpoint.txt and c:\myCheckpoint.xml ... just for grins ... to see if SSIS would generate a checkpoint file for me at the start of the package ... no luck: Message: Checkpoint file "C:\myCheckpoint.xml" failed to open due to error 0x80070002 "The system cannot find the file specified.". From these runtime errors I'v ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Geometry.BoxBoundProbe not working as intended?

  Hi, yesterday I was writing the collision detection code, and I had a really pain, figuring why the code: Geometry.BoxBoundProbe(BoundingMin, BoundingMax, Position, Direction); isn't the same as: if(BoundingMin.X<(Position.X + Direction.X) && (Position.X + Direction.X)<BoundingMax.X)    if(BoundingMin.Y<(Position.Y + Direction.Y) && (Position.Y + Direction.Y)<BoundingMax.Y)       if(BoundingMin.Z<(Position.Z + Direction.Z) && (Position.Z + Direction.Z)<BoundingMax.Z)          return(true); return(false); I ...Show All

• Visual C# How to know the type

  Hi, I have a Hashtable (classLinks). The value can be of two types - either a struct type (HashData) or an ArrayList. The key to the Hashtable is of type string (name). Iam doing the following but it is not working. Type t = classLinks[name].GetType(); if(typeof(t) == HashData) MessageBox.Show("HashData"); else if(typeof(t) == ArrayList) MessageBox.Show("ArrayList"); The compiler is saying "The type or namespace name 't' could not be found". What could be the problem The correct syntax to check if an object i ...Show All

• Windows Forms Combo box with treeview

  Are there any sample code how to create a combo box control with treecontrol being dropped down as the combo expanded. WinFormsUser wrote: The following is the method in my control that does the job. Tell me if you want me to send you the code for the entire control. I don't know how to post it on this site yet. Maybe the moderator that reads this will let me know :) you can paste your code in a word ,and then copy the code in the word to paste here,then the code will show more clearly. and this web ...Show All

• Visual Basic Add New Data Source for My SQL doesn't work

  I have tried also installing and using the ODBC driver version 3.51 and the My SQL driver 3.1.8.  None of these work. What do I have to do to add a new MY SQL data source Michael I was told by two different Microsoft employees that Visual Studio 2005 Express Edition was the right version of Visual Studio 2005 for me to use for all of my needs including access to ODBC and MySQL data. They emailed me a link with a comparison of all of the different variations and features of the different versions of Visual Studio 2005.  I am trying to remember now, but I think it included a chart with bullets or check marks and comment ...Show All

• SQL Server Problem with Execute SQL Task

  I am having problems creating an "Execute SQL Task" which calls a stored procedure. I have tested the procedure successfully using parameters that I have hardcoded on the command line (i.e., EXEC procedure_name 1, 2). This works fine, but I'm having problems using variables(i.e., EXEC procedure_name @VAR1, @VAR2). I'm using a ConnectionType of OLE DB. When I parse the Query I get an error message that says "The query failed to parse. Must declare the variable '@VAR'". However, I have this variable declared and assigned a value. I have played around the Parameter Mapping pane but I'm not getting anywhere. Can anyone shed some ...Show All