el-chema's Q&A profile

• SQL Server need to convert this SQL2000 DTS validation code to SQL2005 SSIS

  Hello, How do I convert VBSCRIPT code in a DTS package which is used for data validation to SQL 2005 SSIS Thanks, Michael Hello, I have a source table which contains some invalid dates (can be null, letters, etc). I want to check to see if the date is valid. If the date is valid then I want to use it. If the date is not valid then I went to set the destination field to null. In the past I used vbscript code like Dim dtStart Dim dtEnd Dim dtSource dtStart = CDate("1/1/1753") dtEnd = CDate("12/31/9999") If Not IsNull(DTSSource("MyDate")) Then If IsDate(DTSSource("MyDate")) Then dtSource = CDate( DTSSource("MyDate")) ...Show All

• SQL Server Server: the operation has been cancelled. - when processing cube

  When I highlight a few partitions and start processing, the process occasionally stops with a message that operation has been canceled, like this: Response 3 Server: the operation has been cancelled. Response 4 Server: the operation has been cancelled. Response 5 Server: the operation has been cancelled. ..etc... (no further error message details are provided) SQL profiler shows that batch was completed (but rowcount shown in process progress log is too small). Analysis Services profiler shows no messages at that time at all. It just shows messages when it started, and when I restarted the processing. The Analysis trace appears to be stopped when processing stops with " Server: the operation has been cancelled.&quo ...Show All

• SQL Server What's wrong with SQL Server E-Leanring?

  Hi, all, Thank you very much for your kind attention. Think I should put this post here for help as I cant find any other forums appropriate for this problem tho. Thanks a lot for that. My question is: what is wrong with the E-Learning for the Microsoft online E-learning courses (the one I am looking at is new features of Microsoft SQL Server 2005 Analysis Services) As I have tried so many times to launch the E-learning tools, but it always just showed me the content while not any tool to start the learning. I have tried ages for that. Could anyone here give me any advices and guidance for that (I actually just used it yesterday, it was fine, but not now I have tried both 'launch e-learning' and 'view e-learning details' , bo ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Render Trouble

  I have encountered some problem using DrawUserPrimitives: I have a triangle list of 40000 triangle disposed in a grid of 200 columns and 100 rows. I'm using 640x480 screen resolution. Initially when I try to render the list I don't have any trouble, but when I move the camera on x-axis, suddenly the engine don't draw anything; moving the camera furthermore, in the same direction, the triangles reappear suddenly again. This is the code that sets the matrix: viewLookUp = new Vector3 (8.0f, 6.4f, 0.0f); viewMatrix = Matrix .CreateLookAt(viewPosition, viewLookUp, Vector3 .Up); projMatrix = Matrix .CreatePerspectiveFieldOfView(( float ) Math .PI / 2.0f, ( float )graphics.BackBufferWidth / ( float )graphics.BackBufferHeight, ...Show All

• .NET Development Determining if an IP is in use on a local network - C# nslookup implementation?

  I want to take an IP and determine if it exists on our local network. I could ping the IP, but that only works if the other computer is connected. Using nslookup from a command prompt works, but how do I get that in code So far the only thing I found in C# is DNS.GetHostEntry. If the IP is in use, it can give me the HostName. But, if the IP doesn't exist at all, it doesn't have a host name, or it just isn't connected right now, it still just returns the IP as the HostName. Any ideas I apologize if this is really obvious, I am new at this. Thanks, Stefanie I can't assume the machine will be connected, but I can assume the IP will exist in DNS. I still can't differentiate between a ma ...Show All

• Windows Live Developer Forums STILL NOT WORKING :@

  I too am having the same problem as the above post. I have vista basic. and i am fed up of using online messenger. I really need Messenger running soon. I had the same problem but I right clicked the messenger icon on my desktop and selected "run as administrator" in the properties/shortcuts/advanced. It starts up every time now. I use Vista Home Premium. ...Show All

• Software Development for Windows Vista timeout errors in SQL 2005

  my SQL studio view is running into timeout error block. how do i insert the SET LOCK_TIMEOUT -1 GO in the SQL statement of the view to allow this to run to completion an example of the SQL view is; SELECT TOP (100) PERCENT dbo.Entry_Race.E_TDR, dbo.Entry_Race.E_Surface, dbo.Entry_Race.E_Race_Class_Codes, FROM dbo.Entry_Race INNER JOIN dbo.Entry_Horse ON dbo.Entry_Race.E_TDR = dbo.Entry_Horse.E_TDR WHERE (CONVERT(varchar(07), dbo.Entry_Horse.E_Date) BETWEEN CONVERT(varchar(07), GETDATE(), 0) AND CONVERT(varchar(07), GETDATE() + 1, 0)) ORDER BY dbo.Entry_Race.E_TDR, dbo.Entry_Horse.E_Horse, dbo.Entry_Horse.E_Traininer This forum is for questions about Windows Workflow Foundation ...Show All

• Software Development for Windows Vista Loading workflow from dynamic instantiated assembly fails

  Hello, We have hosted a windows service with the WWF runtime. This service provides functions to compile workflows on demand. They are compiled to a special repository folder and dynamicaly resolved by our AssemblyLoader to start the workflow. This works everything fine, except ... ..if the workflow is persisted and the workflow is loaded by the runtime itself it can not resolve the DLL because it's not in the execution folder/app domain (bin folder). Questions: -Is it possible to define assemblies to load on runtime instantiation/starting. -Is it possible to find newly compiled DLLs without restarting the service. -Is there another workaround Exception: System.IO.FileNotFoundException: Could not load file or assembly 'CustomWorkflow.4 ...Show All

• Visual Studio Express Editions Combobox and Datagridview

  HI, I apologize if this has been covered. I'm sure there is a quick solution for this. I'm want to be able to take a selection from 2 comboboxes and display this data in a DataGridView. The Comboboxes are filled with data from a Database. Also I only want the GridView window to display data from the selection not everything in the table, so it would remain blank until a selection is made. One last thing, how do I stop duplicate data from being displayed in the comboboxes. Should I setup separate tables and make the tables relational Thanks in advance. Peter Thanks Ahmedilyas, To answer your question is the latter, to based on my selection of the 2 comboboxes to query th ...Show All

• Visual C# Instance Method V Class Method...

  Hello all, When we have: String abc = etc etc; We can call abc.IndexOf(<some string>) Whereas when we have an Array we need to use the class method... string[] bcd = etc etc; The equivalent is: Array.IndexOf(bcd, <object>); They both effectively do the same thing (on their respective objects), i'm just curious as to why the difference in syntax in calling them Thank you Chris Arrays are ordered collections of items of the same data type that are accessed using the array name in conjunction with the offset from the start of the array of the desired item. Whereas a string is a reference type that represents a group (string) of unicode characters. From there it is all in the syntax. Me ...Show All

• Software Development for Windows Vista Downloading Windows SDK

  Okay, I finally found where I can download the .img file for the SDK but come on...over a gigabyte The download page indicates with my 56k dialup connection I would be looking at over 48 hours! It suggests I run the web setup and 'choose only the components I need'. I have access to a broadband connection (for short periods of time) and I have a 1GB flash drive. Is there anywhere I can download just 'the components I need' to a flash drive and then install to my home computer I realize all you guys in Redmond have personal T3 connections but us poor smucks in the hinterlands are still surviving on dialup. How bout throwing us a bone and making stuff like this a little easier to download Thanks. ...Show All

• Visual C# Break execution and jump into code

  In VB, I could break into execution at any time by hitting <ctrl> - <break>. This was useful for debugging stuck while loops and breaking into execution when an error was handled. How is this done in VS2005 There's no 'break' key for C# programs. You can stop execution by going to the IDE window and hitting the stop or pause buttons, which will give you excellent debugging options. Otherwise, e.g. if you aren't debugging or you just want to stop the program, you have to use the task manager. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Maybe I'm an idiot

  First, for some reason I try to use spacewars and after I have the menu open it will not work with my mouse or my keyboard. Also is there supposed to be any graphic editors that come with xna Sorry to waste peoples time, Thanks in advance, Cody 'idiot' isn't a word we like to use round here but if you had searched for forums for 'spacewar keyboard', you would have found a LOT of threads about how to make it work. By default it is controller only. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=682463&SiteID=1 http://www.xnaspot.com/Tutorial_GettingStarted.aspx Please search for your problems before posting. ...Show All

• .NET Development Serializer constructors in sgen generated assemblies ?

  I am currently using the XmlSerializer constructor overload as follows: XmlRootAttribute myRoot = new XmlRootAttribute("myRootName"); XmlSerializer mySerializer = new XmlSerializer(typeof(myClass), myRoot); mySerializer.Deserialize(..); I'd like to pre-generate the serializers with sgen. However, the generated assembly doesn't seem to have a constructor overload that takes an XmlRootAttribute. Is there any way to achieve this Thanks. sgen serializer will use a hardcoded root. You can get the source of the class generated by sgen (using -k option) and then edit that code yourself to emit the right root name. Hope this helps, thx. ...Show All

• .NET Development Decrypting XML from a service

  Hi I have a service where I want to encrypt the database connection string at install time, store it in an XML file, and then have the service decrypt it when it is started. The encryption works well and I can decrypt it from another windows application without any problem, however when the service tries to decrypt the XML document it receives a "bad data" exception. I assume this is because the service cannot access the key container. So what do I have to do to get the service to access the key container here is the solution: makecert -r -pe -n "CN=XML_ENC_TEST_CERT" -sr localmachine -b 01/01/2005 -e 01/01/2010 -sky exchange -ss my -sr localmachine Now the certificate works ...Show All