BobH's Q&A profile

• SQL Server Relability? [part3, zombie, sorting(?)]

  Hello again, It seems that we are pushing IS to the limits :). And again - still SSIS engine version RTM, so my comment may have been addressed in SP1 or HF1. A package is executed by SQL Agent once every day. Once in a fortnight it stalls - goes to the zombie mode. The status of the package in the SQL Agent monitor is "Executing", while log file reports nothing. Now, I believe it is caused by sorting component in the data flow task. I have three reasons for doing so: the log file shows that data sources were read; I think I have seen it once in MS Studio and finally - previous version of the package without sorting worked fine for several months. In our case, we used sorting for merging datasets - we decided to use st ...Show All

• SQL Server Transfering data from DB2 OS/390 to SQL Server 2005

  How can I make a connection in SSIS Data Flow to connect to DB2 on the mainfrain Have several DTS packages in SQL Server 2000 that uses the ODBC connection. Please help! Melvin, can you post more details - you couldn't set the connection meaning you did not find a way to set the connection Or you got errors setting up the connection thanks wenyang ...Show All

• SQL Server Package configuration

  Hi all of us, I'm looking any .dtsconfig file as sample for my first package configuration. I've got ssis packages which might be updated on development and then moved to production. First of all, I'd like dynamically change the connections but I don't know exactly how to do that. I'm taking a look on the wizard but when I choose a Sql Server request me a table. Any sample or link for that would be welcomed! TIA Ok, I begin to understand something... < xml version="1.0" > - < DTSConfiguration > - < DTSConfigurationHeading > < DTSConfigurationFileInfo GeneratedBy =" REDCAM\AdminSql " GeneratedFromPackageNa ...Show All

• Visual Studio Express Editions How to format textbox

  Hi guys, Greetings! Would it be possible to format the textbox in such a way user can only enter numeric data including one period Just like in Visual FoxPro Where the textbox can be pre-formatted during design time such that when user types in, numerals and period are the only valid character that user can only enter. Is this possible If yes on any how, please help. Thanks, Hi ahmedilyas, Thank you! Another question, if MaskedTextBox is possible for textbox entry, how about if I want it in my DataGridView like I have a column there that user can enter the number of items purchase (I prefer to have number separated with comma) just like the validation on my first question : ) ...Show All

• Visual FoxPro export file question

  Hi, I don't know how to export a dbf file to a text file with character fields without quotes. For example, I need that in the text file, fields appear like this: simon 150 manager robert 300 sales representative Thanks, There are 2 ways (at least). If you mean fixed format then as Tamar suggested: copy to filename.txt type sdf Second one is (only remove quotes but keep field delimiter): copy to filename.txt type delimited with "" or: copy to filename.txt type delimited with "" with tab && blank, character   ...Show All

• Windows Forms MULTISELECT ON OPENFILEDIALOG

  I have an open file dialog on a form, and have the multiselect set to true, but I can still only select one file at a time. Any ideas Larry Hilley Are you sure you have multiselect property set to true Can you post some code The typical use would be: string [] files; using ( OpenFileDialog dialog = new OpenFileDialog ()) {     dialog.Multiselect = true ;     if (dialog.ShowDialog() != DialogResult .OK)     {         return ;     }     files = dialog.FileNames; } foreach ( string file in files) {     // Process files here } Andrej ...Show All

• Visual Studio Express Editions Error Installing VC++ or VC# Express Editions

  I have failed to install VC++express or VC# Express with all possible permutations The installations (setup.exe) consistently gives the same error - Suite Integration Toolkit Executable has encountered a problem and needs to close. We are sorry for the inconvenience. Error Signature - AppName: setup.exe AppVer: 8.0.50727.42 ModName: vsscenario.dll ModVer: 8.0.50727.42 Offset: 0003a490 This happens with all downloads - 1. Express down (2MB) of VC++ 2. Express down (2MB) of VC# 3. setup run from ISO images (400+ MB) burnt into CD. I am running Windows XP SP 2. I have also re-installed XP twice and also tried automatic update of Windows. As per installation guidelines, I have removed all BETA installations a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Content Pipeline

  Hi, I haven't really used the Content Pipeline seriously yet but I've seen the official tutorials on it and understand them. Now, I'm thinking - what if I want to load a certain model/effect or anything else that the Content Pipeline supports - BUT I want to load it dynamically/at run-time, e.g. I have a certain filename that my code wants to use to load content, but I don't know it until runtime. Is there some sort of dynamic way of using what otherwise seems to be a static Content Pipeline Thanks... Alex: I would not use the MsBuild approach for what you describe, I would add the file to my project as well as all the textures and create a custom processor to write out the file names. Or your custom pr ...Show All

• SQL Server WHERE clause does not work. Why?

  I am asking for help to resolve this simple problem. It is a stored procedure. It is supposed to return a single row from a table. The table may have max 300 rows but now there is only one row in it. When I execute the query in SQLEXPRESS in the New Query Editor Window with the correct parameter it returns empty row . set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[CentrCtrl_SelectStats] @symbol varchar (10) = 0 AS BEGIN SET NOCOUNT ON; SELECT * FROM dbo.CenC_stocksStats WHERE symbol = '@symbol' END Now, I varied this simple statement this way and that way. I changed it into SELECT * FROM dbo.CenC_stocksStats WHERE symbol = @symbol with the same negative result: empty rowset . If I remove the WHERE clause ...Show All

• SQL Server is there a TSQL statement to delete file like xp_delete_file for SQL2000

  I know there is a command xp_delete_file for SQL 2005 but if I want to delete a file from a 2000 database is there a command to do the same. Cheers, I think I might need to use something like this but was staying away from it as XP_Delete_File allows you speicify a Date. As my transaction log start with EBM LOG Backup<yyyy><mm><dd><hh><mm><ss>.trn and each one only has contains one back up I should be unable to run the above statement and use getdate() to produce the filenames to delete ie xp_cmdshell 'del Backup<yyyy><mm><dd>*.trn else I'll need to write a little app and run that. ...Show All

• .NET Development Can't figure out why node/element is showing as one big text node

  Hello. New to XML using Visual Studio .NET 2003(VB), .Net Framework1.1, WSE 2.0 on win XP Pro, SP2. I'm trying to understand how a specific XML document is structured. I obtained it by consuming a web service. I'll post part of the document at the end of this post. It has trip data for trucks. If i cycle thru the document with this code: (I'm sorry, but i don't know how to post here by using single space carriage return) Me.txtNodeInfo.Text = " " Dim nodeList As XmlNodeList = doc.GetElementsByTagName("*") Dim myNode As XmlNode For Each myNode In nodeList Me.txtNodeInfo.Text = Me.txtNodeInfo.Text & _ "Name = " & myNode.Name & ", Type = " & myNode.NodeType.To ...Show All

• .NET Development c# ms access problem

  Dear All. I have mdb file (office 2003) with table called table1 (F1 int primary key, F2 text). and below is my c# code: private void FM_Main_Load( object sender, System.EventArgs e) { System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(); Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\db1.mdb"; System.Data.OleDb.OleDbDataAdapter DA = new System.Data.OleDb.OleDbDataAdapter("select F1, F2 from table1", Conn); DA.Fill(DS); // DS is the typed dataset with structure as table1 } But when I run my application it gives below error: "The Microsoft Jet database engine could not find the obj ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Is there a program that lets me view .fx files other than rendermonkey or FX Composer?

  I can write my HSLS codes in notepad and save them as .fx files without a problem, but I cant view them, which isnt that big a deal, I guess. I tried to download RenderMonkey and my connection kept getting reset while I doin so. I was wondering if there are any other files that would do the same basic thing as RenderMonkey or FX Composer that are smaller files. Thanks! New Blade3D also have support for FX and error checking in FX files (you can edit FX and see errors). Blade3D is in beta1 and it will be commercial product. ...Show All

• Visual C# With Statement With Word Automation

  How do i change the With Satement in C#....can someone help me out...Take out the look at the code.... I have this code in VB.Net that takes my value in my textbox and writes it to a value in my MS word 2003 document but how do i complete this in C# here is the VB.net code and here is how i began to do it in C# [code language=VB] For Each rng In doc.StoryRanges With rng.Find .Text = "[name]" .Replacement.Text = txtname.Text .Wrap = Microsoft.Office.Interop.Word.WdFindWrap.wdFindContinue .Execute(Replace:=Microsoft.Office.Interop.Word.WdReplace.wdReplaceAll) End With [\code] [ code language=c#] doc = word.Documents.Open( "c:\\dee.doc" ); doc.Activate(); Microsoft.Office.Inte ...Show All

• Visual Studio Team System Code Coverage loses it's mind

  Please refer to http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx feedbackid=FDBK40689 .  I'm now seeing this on other code - non-generic code, so I doubt the original problem has anything to do with generics. Has anyone else seen this kind of behavior   Is there any solution available Having the coloring completely scrambled makes code coverage quite a lot less useful!  Update: Here's the new link on Connect: https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=122653 Hey Carl, I just went and took a look at the MSDN Feedback issue that you filed. Looking at the notes section at the bottom it appears (from Lexin Shan's comment) that this was a problem in the RTM ...Show All