Jim7's Q&A profile

• SQL Server Flat file to DB upload approach question

  Hi guys, Suppose I have a flat file that had columns that went like this: rackId, cdname1, artist1, year1, cdname2, artist2, year2, cdname3, year3, artist3,...cdnameN, yearN, artistN And I want to map it to a table that has the ff columns: rack_id | CDName | Year | Artist Assuming that N is constant and all rows of the flat file will have N or less values filled up per rack, how do I map the fields from the flat file such that cdname1, cdname2 and cdname3 all fall under the CDName column, year1 and so on will fall under the Year column, and artist1 and so on will fall under the Artist column If the number of columns is even across the file; you could use the unpivot transformation on the dataflow http://msdn2.microsoft.com/en-us/lib ...Show All

• SQL Server AcquireConnection error importing dBaseIV files using SQL Agent

  I've got an SSIS package that I've been testing all week and it runs fine in Visual Studio. The package uses an OLE DB connection manager to access the dBase files using the Jet Provider. The dBase files are stored on a remote file share. There are a series of identical files held in different dated folders. I use a ForEach loop to move through the folder list and import the data as I go. When I deploy it to the server and try to run it, I get the following: The AcquireConnection method call to the connection manager "Aloha" failed with error code 0xC0202009. Aloha is the ConncetionManager to the dBase files. I've searched everywhere I can for ideas on how to solve this. I've made the SQL Agent Service is running under the ...Show All

• Software Development for Windows Vista Communication with the underlying transaction manager has failed.

  Does anyone know how to resolve this exception. Exception: Message: Communication with the underlying transaction manager has failed. Stack Trace: System.Transactions.TransactionManagerCommunicationException: Communication with the underlying transaction manager has failed. ---> System.Runtime.InteropServi ces.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component. at System.Transactions.Oletx.IDtcProxyShimFactory.ReceiveTransaction(UInt32 p ropgationTokenSize, Byte[] propgationToken, IntPtr managedIdentifier, Guid& tran sactionIdentifier, OletxTransactionIsolationLevel& isolationLevel, ITransactionS him& transactionShim) at System.Tran ...Show All

• SQL Server how to set the report header that dependent of matrix

  Country to country Destination Country Valid Mail Austria Belgium Austria 1.9 1.7 1 23 23 Belgium 1.7 9.7 2 23 23 Valid Mail 1 2 3 hi, matrix have dynamic column.So how we can set the header"Country to country" that always display at center of matrix Can i use report header to display 'Country to Country' Thanks Best Regards, Penny Put a table control on your report Delete all but 1 column Right-click and hide the details section drag the matrix into the footer section put your heading into the header section and center the text T ...Show All

• SQL Server Declare cursor based on dynamic query

  Hi, I am declaring the cursor based on a query which is generated dynamically. but it is not working Declare @tempSQL varchar(1000) --- This query will be generated based on my other conditon and will be stored in a variable set @tempsql = 'select * from orders' declare cursor test for @tempsql open test This code is not working. please suggest Nitin hey whitney, i got the same problem of dynamic query with cursors.. You gave the alternative but i got the big cursor and its difficult for me to put the entire stuff in string. Because it gets difficult to maintain for me. Any help or comment regarding this will be appreciated. Thanks a ton!! d ...Show All

• Software Development for Windows Vista How can i use multi-VMR9AlphaBitmap with VMR?

  I want to display a few semi-transparent images over the video, and echo image has its own alpha value. However, only the last one would be displayed when i try to apply multi- VMR9AlphaBitmap on the VMR. What should I do Can anyone help me   THX I think you'd have to create a composite image of all your layers first then use that for the VMR image. See the AlphaBlend function. --nick ...Show All

• Windows Forms Predicting the behavior of ToolTip.Show and ToolTip.Hide

  I'm trying to develop a panel that will paint different pieces of information. Essentially serveral different rectangles which represent different pieces of data. I would like tooltips to show a little more detail information for each rectangle. The test case would be for the user to move the mouse to rectangle 1, the tooltip to show for rectangle 1 after initial delay, the user moves the mouse to rectangle 2 (within the same panel/component), the tooltip disappears when leaving rectangle 1, the mouse settles on rectangle 2, after the reshow delay the tooltip will be redisplayed with the information on rectangle 2. Currently, just setting the text results the tooltip being continuously displayed after the initial display. I can't get i ...Show All

• SQL Server Disabling Repl error (22538)

  Posted - 02/01/2007 : 22:35:02 Try dropping the subscriptions before trying to disable publishing and distribution. If you still have issues cleaning up, try using sp_removedbreplication at the subscriber and publisher. You can get more information on sp_removedbreplication from http://msdn2.microsoft.com/en-us/library/ms188734.aspx Hope this helps, Tom This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• .NET Development peer to peer application, what to choose? wcf or .net remoting

  Hello!! I hope you can help me about my choice. I have to write peer to peer application. Now I would like to intorduce the most important funcionality of this system. 1. Every node should have connection to each other. 2. Each node should have the same synchronized and integrated dictionary, database.. 3. Each node should be able to change dictionary without danger of loosing integrity. 4. The main task of applicatoin is to process objects. Different nodes have different skills in processing objects. For example node A processes object and then sends it to node B which completes processing, object dies and node B makes a new registration to common dictionary. I am searching all the time technology, which would be the best I also concern i ...Show All

• Visual Studio Express Editions Another database question

  Is it possible and how would I go about making a database full after say 15 Items are added to it that the database would no longer except new entry's Would be inefficient use of a database!   however you can do this.   you can do a statement:   SELECT COUNT( columnName ) FROM tableName This will count number of entries/records in that table.   Then simply read the value returned using a DataReader   OR   you can fill a datatable/dataset with the records and count the rows to see if there are 15 records, however this would be very inefficient.   So sticking with the first solution...   Dim theSqlCommand as new SqlCommand(" SELECT CO ...Show All

• Visual Studio Programmatically remove web reference

  Hi, I'm working on an addin that needs to programatically remove a web reference from the VSProject (for C# projects) and VCproject (for C++ projects), but i can't seem to find the API calls that do that. It the proper way just to get the ProjectItems list from the WebReferenceFolders and call ProjectItem.Remove() on the particular item I want to remove Thanks and regards, Pix ...Show All

• Smart Device Development 'CEmbeddedButActsLikePtr<TYPE>::m_data' uses undefined class where afxtempl.h is included

  I am porting an embedded VC++4 project to Visual Studio 2005 and need to build for Windows Mobile 5. This project uses CList, which requires the inclusion of afxtempl.h. However whenever I include this file I get the following copiler error: C:\Program Files\Microsoft Visual Studio 8\VC\ce\atlmfc\include\afxstat_.h(127) : error C2079: 'CEmbeddedButActsLikePtr<TYPE>::m_data' uses undefined class 'CMap<KEY,ARG_KEY,VALUE,ARG_VALUE>' ...Show All

• Visual Studio 2008 (Pre-release) ServiceContract hierarchy?

  Hi, We have a server written with .NET Remoting, which we are now trying to integrate with WCF, but there is an issue which we can't seem to find any solution for: Let's say our main interface looks something like this: public interface IApplicationServer { ISmartTrigger SmartTrigger { get ; } ... } public interface ISmartTrigger { int AddSmartTrigger( int TriggerID); } The implementation is not critical at this stage. In general, the main object (ApplicationServer) will only hold other objects (like SmartTrigger), which have our API methods declared in them. This is a logical division which we've made, our IApplicationServer interface holds more then 20 objects and each of these objects hold a ...Show All

• Visual Studio Single stepping seems to not work correctly

  I'm writing a small program in C using Visual C++ 2005 express edition. I try to singlestep in the below listed function with weird results. I have breakpoint at the start of thefor loop. First thing i is reported to have a 11 digit valu instead of 0. Then when I single step the first turn in the foor loop is as expected but then when I press F10 I go directly from the strp++ after else ti the j=i statement in the if code and that makes no sense float Evaluate( char *strp) //Evaluate an arithmetic "partstr=%s\n" ,&partstr[j]); Processstr(&partstr[j]); strp++; j = i; } else strp++; } result = Getoperand(); return result; } Final thoughts: Physically delete all objects and libra ...Show All

• Visual Studio Team System TF14087: Cannot undelete...because not all of the deletion is being undeleted.

  Hi folks, I am seeing the following error when attempting a merge: TF14087: Cannot undelete '$/Ammado/trunk/Source/Ammado.Web.UI/Controls/LoginPanelControl.ascx.cs' because not all of the deletion is being undeleted . I'd like to get to the bottom of it. Basically, our setup is that all developers work on a branch, and when they have changes to commit to the trunk, they - first merge TO their branch from the trunk, - resolve, test and checkin, - merge FROM their branch TO the trunk - run the automated build and check that the trunk still builds I attempt a merge from the trunk to my branch, and Source Control Explorer says that there are no changes to merge I then attempt to merge from my branch to the trunk and I see the error above. $/ ...Show All