barkingdog's Q&A profile

• SQL Server DTSTransform.DataConvert programmatic access?

  I am trying building a package from code. I have been able to follow the SSIS samples and build my control flow with foreach loop and SQL Commands pretty easily. The data flow has been a different story, I am struggling with input and output columns. I trying to read from a flatfile, convert data, perform a lookup, and update or insert based on the results of the lookup. I was able to build this package in the designer and it works just as I want, but I am having problems duplicating the data flow in the code. I was able add the flatfile, data conversion, and insert controls on the data flow and linked them together. However, I cannot figure out how get the input columns in the data convert object to become selected and generate the ...Show All

• Windows Live Developer Forums Bug using window.external.Users and IE7

  Hi, I've been working on a Messenger activity and keep running into a problem with Live Messenger and IE7. For instance, if I create a web page and include this script in the body: <script type="text/javascript"> if (window.external.users.inviter === window.external.users.me) { document.write("I am the Inviter."); } else { document.write("I am not the Inviter."); } </script> On a machine running IE6 it works as expected on IE7 I get an error "Library not registered" Any help is greatly appreciated. This is a HUGE problem! Thanks. I am not using IE7 so I can't test it, but I think you just made a mistake in your code. It' ...Show All

• .NET Development Invalid Server Binding Status Problem

  Hi, First, sory for bad english. have installed VS 2005 Team Suite on Vista and installed the VS 2005 SP1 and VS 2005 SP1 Vista Update. Still have same problems. The big one is: open an existing solution from the source control (TFS). The solution contains four projects. (class library, win app, web project and web service project). Win app and class library has no problem but web and web services projects come with no files until when i use the get latest command with the force option. After i get the all files for solution from the source control, i close the VS and reopen solution again. When solution fully open and ready, the server binding status for all project in the solution goes invalid and all lock icons disappear. using ...Show All

• Visual Studio Team System build script question

  Is there any way to avoid this batch from being generated at the begining of build script: GO :on error resume :on error exit IF (@@servername != 'devsrv') BEGIN RAISERROR(N'The server name in the build script %s does not match the name of the target server %s. Verify whether your database project settings are correct and whether your build script is up to date.', 16, 127,N'devsrv',@@servername) WITH NOWAIT RETURN END GO We would like to deploy build script to multiple servers but without rebuilding the project each time with different configuration. only thing that's wrong in script is above server name check. I know we can remove it manualy but maybe there si some switch or build parameter we can set that will exclude ...Show All

• .NET Development dll version conflict

  I am using Visual Studio 2003 to develop a project using the open source DotNetNuke portal framework. I have created two projects named Financial and Financial.SqlDataProvider. Both have references to DotNetNuke and Financial.SqlDataProvider has a reference to Financial. When I try to build the solution I get two errors. The first is: Error: The dependency 'CountryListBox, Version=1.0.2182.21387, Culture=neutral' in project 'Financial.SqlDataProvider' cannot be copied to the run directory because it would conflict with dependency 'CountryListBox, Version=1.0.2182.41880, Culture=neutral'. The second is the same but with the version numbers flipped. I have found that removing the DotNetNuke.dll reference from either of my projec ...Show All

• Windows Forms controls library

  hi, ive got a controls library. now if i want to use these controls in any project, i want to drag and drop feature with the controls . how do i i want to be able to have the controls displayed on the toolbar , thesame way it would if the usercontrol was created in the project Hi, I guess you mean "have the controls displayes on the toolbox " If it is, then right click on the toolbox, choose "add items..." and add the .dll file. Then the controls will be displayed on the toolbox. ...Show All

• .NET Development Setting/getting encoding property

  Is there any way to get/set the 'encoding' property of a DOMDocument The following works: var doc = new ActiveXObject( "Microsoft.XMLDOM" ); doc.load( "test.xml" ); // Print initial encoding var pi = doc.firstChild; var eattr = pi.attributes.getNamedItem( "encoding" ); var encoding = eattr.value; // Convert to string and reload (this loses the encoding) var xml = doc.xml; doc.loadXML(xml); // Reset the encoding to "ISO-8859-1" pi = doc.firstChild; var eattr = pi.attributes.getNamedItem( "encoding" ); if (eattr == null ) { eattr = doc.createAttribute( "encoding" ); pi.attributes.setNamedItem(eattr); } eat ...Show All

• SQL Server finding the date of the last thursday

  can anybody help me with the query to find the date of the last thursday for the given month. is it possible to do it without using any kind of loops. Thanks in advance Jacx Use the following function, Here @Searchday is 1=Sun 2=Mon .. 6=Sat Create Function dbo.GetLastWeekDayof(@Searchday int, @Date as datetime) returns Datetime as Begin Declare @Lastday as datetime Declare @LastWeekDay as Int Declare @Result as Datetime Select @Lastday = DateAdd(dd,-1, DateAdd(MM,1, Convert(datetime, Convert(Varchar,Year(@Date)) + '-' + Convert(Varchar,Month(@Date)) + '-01' ) ) ) Select @LastWeekDay = Datepart(w,@Lastday); Select @LastWeekDay=Case When @LastWeekDay >@Searchday-1 Then @LastWeekDay - @Searchday Els ...Show All

• SQL Server Log Events is interrelated with Event Viewer Windows?

  Hi everyone, I was wondering how do for 'Log Events' info going to Event Viewer Windows visor. Is it possible or it's just only private info for you SSIS. Thanks for your input, Hello. If I follow, what your asking, its if in the SSIS 'Log Events' tab/window, you can see Windows Events, those not associated with SSIS If so the answer is no. The Log Events window will show only events that SSIS generates, though it does not matter if you are currently using a SQL log provider or a windows event log provider. Hope that helps. ...Show All

• Windows Search Technologies Protocol Handler: Open items from WDS Search Deskbar

  Hello, I have a working WDS PH prototype. My SearchProtocol Class implements IShellFolder and IPersistFolder. Thus the WDS explorer window displayes my own icon (IExtractIcon) and i can open items (IContextMenu). But how can I interfere in the WDS deskbar quick results It seams that the IShellFolder.GetUIObjectOf is not called here. How does it work Thank for any help! Martin Ah, I thought that was probably the case. Unfortunately, WDS doesn't currently support opening items via 3rd party protocol handlers from the quick search window generated by the toolbar. We've run into this problem with a few of our own protocol handlers and are hoping to resolve it with a future release. For now, items ...Show All

• Smart Device Development Get processor usage

  Hi, does anybody knows how to get processor usage percentage, i mean like how it looks at the windows xp task manager. thanks in advance I would guess that would be a sum of 3 and 4 divided by current time minus #1. You can run a little experiment to confirm that. ...Show All

• Software Development for Windows Vista Dynamic interface to workflow

  Hi, I have a question about making a dynamic interface to workflows. I have searched thru the forums, but can't find any similarities with my problem, so I post it here. If I mistakenly missed another similar posting, please do direct me to that post. The background first. I'm trying to separate the workflow from the application that I'm developing. Let's call the application "AppX". AppX has a lot of modules, and requires multiple number of workflows for approval processes. So, I have to create several workflows in WF. In the end, I will have AppX and several workflows. All workflows are State Machine workflow, which is the most "matched" model to approval process. Since I'm trying to separate AppX from the workflow, I ...Show All

• SQL Server Mapping of variables while passing a resultset to foreach

  I have an Execute SQL Task1 that executes an extraction stored proc (say spe). spe returns a rowset that has 25 columns. For each row in the rowset, a load stored proc (say spl) has to be executed (spl is executed using Execute SQL Task2) . spl has 25 input parameters that match the 25 columns returned by spe (the column names returned by spe and input parameter names of spl are exactly same). To achieve this, in Execute SQL Task1 , I had to specify a variable in the Result Set (say User::resultset). After declaring 25 variables, in the foreach loop editor, I had to specify the Variable Mappings of these 25 variables to the column indices of the rowset returned by spe. After this, in Execute SQL Task 2 I had to specify in th ...Show All

• Visual C# Set and Get text file properties

  Hi All, My application creates text files. I need to modify, programmatically, the created file's properties (available via righ-click > properties > Summary). Example 1: Set the string "Modified by Jack" into the comment field. Example 2: Get the Revision Number. Thanx, El. take a look at this my friend: http://www.codeproject.com/csharp/dsofiledemo.asp ...Show All

• Visual Studio Tools for Office Deployment walkthroughs are useless!

  OK. I love the concept of VSTO 2005. It took me very little time to develop an add in for MS Excel. It took me nearly 20 times the development time to deploy. This is the hardest environment I have ever had to deploy, I have developed in Foxpro, Standard VB .NET, ASP.NET etc. However, the walkthroughs for VSTO are useless. I followed these and my app would only work on the development machine. I kept getting the standard .NET security error. I used caspol, Deployment wizard etc to no avail. In the end I ignored the walkthrough step that said exclude assemblies and basically created my own set up program. This ended up working. I have to say I will be very reluctant to ever develop another solution based on VSTO again unti ...Show All