Terrence Chan's Q&A profile
SQL Server SSIS Dynamically Naming Output Files
I've just started using SQL Server 2005 Integration Services and I've come up against a situation where I need to name output files dynamically (i.e. based on a timestmap). Looking through this newsgroup, and other web resources it looks like my only option is to use a Script Task/ActiveX Script Task to rename the file after it has been created with a generic file name. I was wondering if there was a different approach or if there was a way to pass in a variable to the file connection manager that I could append to the file name at run-time. Thanks Bill You can use a variable in an expression, as applied to the connection string property of your connection, e.g. @[User::FilePath] + "\\" ...Show All
Visual C++ error in passing a CTypedPtrArray object
Hi, CTypedPtrArray<CPtrArray,SScreenDetEntry*> m_DestArray; I have declared a variable or u say object watever... of the one u see above...in which SScreenDetEntry is a structure. I have filled in data into this variable and trying to pass this to another function like screendetails(m_DestArray); where screendetails func also accepts similar variable when i compile i am getting the error as shown below Uxx_MS_FileDiffTree.cpp WINVER not defined. Defaulting to 0x0502 (Windows Server 2003) Warning! This release of Objective Views is not supported with versions of MFC newer than 7.10. Contact Stingray Software to obtain an update. Automatically linking with OC800d.lib Automatically linking with RWU ...Show All
Visual Studio 2008 (Pre-release) Retrieving Information from a RichTextBox Selection
Hi, I would like to know how to retrieve the inlines contained within a selection. I have tried various ways to retrieve the exact inlines contained whithin the selection, but I never get accurate results. Can someone please help Thank you, Jaco Jaco, your approach looks reasonable. I wonder if the duplication is because you hit the InlineUIContainer start AND end edge while iterating through the content: <InlineUIContainer>[start]<UIElement/>[end]</InlineUIContainer> As you iterate through the above content, tpCurrent.Parent will be an InlineUIContainer in two places -- [start] and [end]. You could use logic like if (tpCurrent.Parent is InlineUIContainer) { st ...Show All
Visual FoxPro Why tooltips won't work for Expressions?
I've noticed that tooltips won't work for expressions. I'm refering to the tooltips VFP provides when the with of the column is smaller than its content. Is there a way to make tooltips work for column1 in the grid below Public oForm oForm = Createobject('MyForm') oForm.Show Define Class MyForm As Form Width = 420 Height = 460 showtips=.T. Add Object grd1 As Grid With ; left = 10, Top=45, Width=400,Height=200,RecordSource='Orders' Procedure Load Use (_samples+'data\orders') In 0 ENDPROC PROCEDURE init thisform.grd1.column1.controlsource= "('The quick brown fox jumps over the lazy dog')" endproc Enddefine I don't know why. It sounds the ...Show All
.NET Development Counting values in a hash table
I am populating a hash table with values retrieved from a dataset. Once the data is in the hash table I'd like to query against the hash table, look for a particular value and then have a count of that particular value returned. Not having worked with hash tables before I have no idea how to do this; nor do I know if employing a hash table is indeed the best way to accomplish this, so if anybody has a better idea I'd be very appreciative to be told so and given an example. Thank you. Sean. I assume you want to do something like this: foreach(DictionaryEntry dictionaryEntry in hashTable) { Debug.WriteLine( dictionaryEntry.Key.ToString() + " => " + dictionaryEntry.Value.ToStrin ...Show All
Visual Studio Team System Recording Atlas (Ajax) control
Hello, After recording a web test with a page including an Atlas control, there is no Form Post Parameter recorded from the page. How can I go around it Thank you in advance for your help Jeanvo QA SWEA supports both approaches: it detects DOM changes and analyzes network traffic to "simulate" the missing browser complete events. ...Show All
Visual C# Error in Visual Studio (C#) AND Visual Studio (C#) - Data Source
Hello- I am receiving the same error message within Visual C# Express Edition as well as Visual Studio 2005 when I attempt to add a new data source in my project. The error I keep recieving in both Visual C# Express and Visual Studio is "An error occured while creating the new data source: Could not get the type information for 'Lesson09.Database1DataSet' ". Why is that and what does that mean I cannot proceed with my lessons because I cannot get past this point to participate. I have also tried opening a sample project which uses the same techniques and also recieved errors while loading it into Visual Studio as well as C# Express Edition. I get the following build errors: 1- Error 1 ...Show All
Smart Device Development how to start app without form?
I have a windows mobile 5 app with compact framework 2.0 in vb 2005. I want to start the app by initialising my controlling class - I don't want to start the app with a form. The problem is I can't use application.run() - I have to use application.run(formname) but as the app is a wizard app the first form may be different each time. My controlling class knows what form to show first but of course when it does the whole app exits straight away as I haven't used application.run from sub main. Any ideas sub main code below. Sub Main() ' Prompt for login. Dim Login As New frmLogin Dim LoginResult As Integer = Login.PromptForLogin() Select Case LoginResult Case frmLogin.LoginOutcome.Successf ...Show All
Visual Studio Team System Why don't I have contributor rights?
I'm evaluating TFS using a workgroup edition. Apparently I have no contritutor rights. When I right click the project node in VS it says No Commands Available. I can see the files and folders in the source control explorer but all check in, check out etc operations are disabled. I'm a member of the following groups ( UnikTest is the name of the project in question): [SERVER]\Team Foundation Licensed Users [UnikTest]\Contributors [UnikTest]\Project Administrators The project groups are members of the Team Foundation Valid Users group. The project was created using a wizard. The TFS user used to setup TFS, SharePoint and Reporting services has contributor rights (can add files and folders etc.). I've followed the guide Team Foundation Serv ...Show All
Windows Forms .NET app checks for original install location before running?
It appears that when I install/deploy my .NET 2.0 app using a Deployment Project within my app solution, the first time my app runs it checks the the MyApp.MSI in the location from where the install was originated. Is there any way to prevent this behavior My app is NOT deployed as a ClickOnce app and is not published so I don't understand why this check is happening My deployment files are: Setup.EXE MyApp.MSI CRRedist2005_x86.MSI What I usually do is combine these three files in a single WinZip self extracting to produce an end result of MyAppSetup.EXE. This all works fine with ONE exception, WinZip self extractor will remove the above 3 files from the temp folder it creates. This becomes a problem because when I click on th ...Show All
.NET Development We're not supposed to use List<T> ? ( List )
I installed FxCop and had it analyze my application. In several spots, it says: "Do not expose List<T> in object models. Use Collection<T>, ReadOnlyCollection<T> or KeyedCollection<K,V> instead. List<T> is meant to be used from implementation, not in object model API. List<T> is optimized for performance at the cost of long term versioning. For example, if you return List<T> to the client code, you will not ever be able to receive notifications when client code modifies the collection." I'm a bit weak in my OO.. so I'm not sure what "expose" really means in this context. Is this saying to not use List<T> ...Show All
Smart Device Development windows mobile 2003 SE and net cf v2
I moved from using visual studio 2003 to develope an application for a windows mobile 2003 SE PDA to vs2005. After some problems this now works. However when I upgrade to using .net cf v2 and download to the PDA the forms in the application become compressed to appox. a quarter of their origial size. The menus are still in the correct place its just the size oif the forms. Has anyone else had this problem, does anybody know of a solution I already have NETCFv2 SP1 installed. Thanks Rob I'm not quite sure what you're asking. Your thread is right here, you can post to it, right As to initial issue, please make sure you've added code above for all forms in correc ...Show All
SQL Server Sending Table Variable Argument using MSFT JDBC Driver
I want to call a stored procedure that has a table variable as its parameter. I am using the MSFT SQL Server 2005 JDBC driver 1.1, however I don't know how to construct a table variable from the Java side to place within a CallableStatement. The CallableStatement interface allows me to set various types of parameters (e.g. Boolean, Byte, Blob, Array, etc.) but I don't see anything for table variable. Is there a way to do this Developer: The two main methods that I use for doing what you propose is (1) create a temp table and have the stored procedure operate on the external temp table or (2) pass a "string list / string table" to the stored procedure; this article will help if you cho ...Show All
Windows Forms DateTimePicker column not holding edited values when tabbed off control
Does anyone know if Microsoft will be including a DateTimePicker column in the DataGridView (for underlying date values) The current article says "TextBox, Image, CheckBox, ComboBox, Link, and Button column and cell types" will be included. I'm hoping for a DateTimePicker one as well... From: http://www.windowsforms.net/WhidbeyFeatures/default.aspx PageID=2&ItemID=13&Cat=Runtime&tabindex=5 Sorry to bring up an old thread. I would be ...Show All
SQL Server Retrieving Hierarchy Captions from a Cellset
I'm trying to retrieve the hierarchy caption(s) for a given axis in a cellset, but whenever I try to retrieve this: cellset.Axes(0).Set.Hierarchies(0).Name I get an exception like this: System.ArgumentException was unhandled Message="The '[Date].[Calendar Quarter]' object was not found.\r\nParameter name: uniqueName" Source="Microsoft.AnalysisServices.AdomdClient" ParamName="uniqueName" StackTrace: at Microsoft.AnalysisServices.AdomdClient.CubeDef.InternalGetSchemaObject(SchemaObjectType schemaObjectType, String uniqueName, Boolean retryUniqueName) at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetObjectData(SchemaObjectType schemaObjectType, String cubeName, String uniqueName) ...Show All