afita's Q&A profile

• SQL Server Create a flat file for each record in a table

  I'm rather new to ssis and I've been reading and testing but didn't find a solution for this problem.Supose I've got a table Customer with some fields. One of the fields is CustID.I want to create as many flat files as there are Customers in the table with flat file name set to the CustID.If you could point me in a good direction, It would be nice.Greetings from Belgium Do you want any data in these files or just the file to be created If you just want the file to be created you could aggregate the data and then use the FileExtractor to create the file (You would need to add 2 columns one for the file name ...Show All

• Visual Studio Team System How to get list of SC files associated to Work Item

  Hello, We frequently update our web application. On each enhancement we might change some files. In VSFS I would create Work Items for any changes, associate a Work Item to the Checkin. When time comes to update files on the production server, we want to update only the files that have changed and the project DLL. How do I get a list of Source Control files that were associated with a particular Work Item in Team Foundation Server Thanks Mike You can write a report to get this information. In excel connect to the cube: make pivot table / analysis Services & olap 9.0 as data source ...Show All

• Visual Studio Team System Adding files to TFS source control without a team project

  Is it possible to add files to the TFS source control without associating them to a team project I have a couple of files that aren't under any project management which needs to be put under source control (for proper backup etc). If this is not possible, can I add a new team project without using a process template, not creating a sharepoint site, etc, etc. /Chris ps. I searched the forums for this kind of question but I couldn't be bothered finding an answer amount the thousands of hits I got :) No, the top-level folders in source control are always Team Projects. If you don't need the project man ...Show All

• .NET Development TableAdapters/XSD Schemas/XPath Query and the Update Function

  I am starting a new thread as I have not seen in other threads people using the same combination of technologies. I have been working on this problem for the last 2 weeks and am completely stumped!!!! Here is the scenario: I am having problems with SqlXmlAdapter.Update.  I am running Visual Basic Express 2005 and SQL Server Express 2005. Here is the code that does not work...  I hope this is enough to work with... ____________________________________________________________________________________________ Dim mvarConnection as String = "Provider=SQLOLEDB;Server=" & sqlServer & ";database=" & sqlDatabase & ";user ...Show All

• Windows Forms License agreement in setup

  Hi, How can i add license agreement screen to the setup Thank's Alexei Hi, I have found the solution. I need to add license agreement dialog in User Interface of setup project. Also set file to license agreement file. Thank's Alexei ...Show All

• .NET Development ADO/SQLExpress Connection String Question

  I'm working on a customer project and deployment project. SQLExpress is part of the installation and there is a pre-existing database. As installed, the database is detached. This application uses ADO.NET to establish SQL connections and it also uses Excel VBA to connect to the database via ADO. The following SQL Connection string works for SQL (as far as I can tell) Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\XYZ_Data.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True What is the appropriate ADO (not ado.net) connection string The one that has worked when the database is attached looks like ...Show All

• Software Development for Windows Vista ASP.NET hosting (WebService) of Windows Workflow Foundation

  Hi all, I've decided to go about hosting the runtime in an ASP.NET environment, specifically a webservice. All is looking good on the 'design table' except for ONE thing...... Upon hosting the WorkflowRuntime, and I fire up a sequential workflow, how do I know when it's finished (I'd like to be able to use the Async features in ASP.NET 2.0) The reason why I ask is most of the examples either wait on the current thread - waitHandle.join() etc., or workflowRuntime.WorkflowCompleted += new ......run my workflow completed routine. At any point in time there could be 200 workflows running and I dont want all the pages with registe ...Show All

• Visual C++ whats wrong with declarign a pointer?!?!?!?!

  hey guys, this is dead simple, i have an mfc application with shared dll. i declare a pointer as follows: int* t = new int [2]; and its exceptioning saying out of memory! wahats wrong with that i know that i can do it using int t[2]; but i want this as a breif explaination of another problem i have. i cant spot why it doesnt like it at run time! That shouldn't cause a memory error! Show more code and provide more contextual info! egyptian_bean wrote: hey guys, this is dead simple, i have an mfc application with shared dll. i declare a pointer as follows: int* t = new int [2]; and its exceptioning ...Show All

• .NET Development Problem with .net COM Application when i use 2 Frameworks[v1.1.4322, v2.0.50727]

  Recently i developer an application with microsoft .net[v2.0.50727]]to close the moviments of the bank. This application is working very well. The problem is when one machine(server) have 2 frameworks installed [ v1.1.4322, v2.0.50727]. This machine have .NET applications[v1.1.4322] registred in COM, when i installed the .net Framework [v2.0] there applications don't work correctly, i resource in the internet and my conclusion is when one machine have .net application in COM the .net engenieer[ mscoore.dll] execute the application using the most recent version of the framework. I maked a small program to demonstrate this. How can i correct t ...Show All

• Visual Studio local MSDN with VS2005

  Hello After reading posts about MSDN and trying suggested solutions I cave still problems to install it. I had VS2003 witj MSDN October installed on my XP SP2 PC. Then I've installed VS2005 from CDs version and MSDN October from DVD as a result no help was available on 2005. I've tried repair, then reinstall, then uninstall VS2005 and MSDN and re-install again. Nothing Then I've removed everhithing: VS2003, 2005, MSDN, MSSQL (all) Document Reader .Net 2.0 (1.1) left, J# 2, XML6 (I've missed perhaps something) Restart and then I've installed VS2005 & MSDN October Now I'm at this point and again I cannot open MSDN from VS2005, neither coul ...Show All

• Visual Basic password in access

  Hi! Happy new year  to all VB Guru out there my previous query was solved in a couple of days, I am stuck again, i am doing a project with access has a database and VB 6.0 has a front end. I want my database to be password protect i.e if any dblclick access file it must ask for a password. Can i link a password protect access file to VB if tried but error like worksheet file not found was thrown, can any VB GuRu out there let me know the steps in accomplishin the task. Also i want in my project to display mathematical formulas, has some fine guy know how to store mathematical formula( like sin2A + Cos2A=1 here '2' must be ...Show All

• Visual C++ Microsoft Visual C++ Runtime Library error question

  I recieve this error when I launch Internet Explorer - version 6.0 OS Windows XP Home edition 2002 Service Pack 2.  Error is as follows: Microsoft Visual C++ Runtime Library Runtime Error! Program C:\Program Files\Internet explorer\iexplore.exe This application has requested the Runtime to terminate it in an unusual way.  Please contact the application's support team for more information. I am not certain where to post this question and problem.  Your assistance is greatly appreciated.  Currently, I am using Firefox as my back-up web browser.  I have seen a similar Problem. The Culpret was a corrupted Mc ...Show All

• Visual Basic Populating Combobox with distinct data from a datasource

  Hi, I have a database which contains the field "Date". The database is such that, one "Date" can have many entries. When I populate a combobox with the data from this field, I get a date multiple times. I would like to know if there is a way, that I can group all the dates under one category. (NB - Selecting a date returns the data for that particular ID - not all the data that the date falls under - even if I have a query which uses the actual date, rather than the ID) Thanks in advance, Sahil Can't you use the SQL keyword distinct in your SQL selection example: ...Show All

• Visual C++ Image Color Management in VC++ 8 Platform SDK

  I'm converting a VC++ 6 MFC app to VC++ 8 using Visual Studio 2005 Standard. The existing app uses Image Color Management, so it #include's icm.h. In the VC++ 6 environment, it is included from the Platform SDK [$(ProgramFiles)Microsoft SDK\include] directory. A Visual Studio .Net installation delivers a version of the Platform SDK in a subdirectory of the VC directory [$(VCInstallDir)PlatformSDK] and this directory is setup to be used for includes upon install. However, icm.h is not included in this version of the Platform SDK delivered with Visual Studio 2005. The file does exist in both VS2002 and VS2003 installations. Was this ommi ...Show All

• SQL Server Just the time...

  Hi, I'm new to SQLServer and I would like to know how I store times without dates! I simply want to store a duration which has no concept of a date, but I cannot seem to find a data type that does the job. Am I missing something obvious Cheers, Roy Seems reasonable, efficient and obvious! I don't need to store anything less than seconds so this will do nicely. Cheers, Roy ...Show All