vicky_vigia's Q&A profile

• SQL Server Writing data from multiple tables to a single flat file

  I have a package that contains three database tables (Header, detail and trailer record) each table is connected via a OLE DB source in SSIS. Each table varies in the amount of colums it holds and niether of the tables have the same field names. I need to transfer all data, from each table, in order, to a flat file destination. I have created a flat file connector containing all the necessary fields that need to be transferred from the above three records. Header record contains 1 row of data. 4 colums Detail record may contain numerous rows. 28 columns. Trailer record contains 1 row of data. 4 columns. I need to write the row of data ...Show All

• Smart Device Development Close CameraCaptureDialog and ShowDialog

  Hi all, I need help because I'm developping an application in C# on a WM5.0 smartphone (C600). In this application, I use the cameraCaptureDialog to take picture. Here's the code : public partial class Form1 : Form { public Form1() { InitializeComponent(); CameraCaptureDialog cameraCapture = new CameraCaptureDialog (); cameraCapture.ShowDialog(); } private void menuItem1_Click( object sender, EventArgs e) { Application .Exit(); } } So, as you can see, when i launch the application, there is the camera capture dialog and i can take picture with it. And when I have ...Show All

• SQL Server new fact records

  Hi there Is there functionality in SQL 2005 to update only new records, e.g. only records from yesterday. I've seen functionality for dimension tables to only get new records but nothing for fact tables. Thanks Read this and try method 2: http://www.sqlis.com/default.aspx 311 -Jamie ...Show All

• Software Development for Windows Vista Please help

  When I try to build an old project which uses directx to show videos. there are errors as follows Linking... ConfigDlg.obj : error LNK2001: unresolved external symbol _CLSID_AudioRendererCategory ConfigDlg.obj : error LNK2001: unresolved external symbol _CLSID_AudioInputDeviceCategory ConfigDlg.obj : error LNK2001: unresolved external symbol _CLSID_VideoInputDeviceCategory ConfigDlg.obj : error LNK2001: unresolved external symbol _CLSID_SystemDeviceEnum CyklOneDlg.obj : error LNK2001: unresolved external symbol _CLSID_SystemDeviceEnum Graph.obj : error LNK2001: unresolved external symbol _CLSID_SystemDeviceEnum ConfigDlg.obj : error LN ...Show All

• Windows Search Technologies Search doesn't work.

  When I search for a file or folder, it will search for all of 2 seconds then say that there are no results. I even tryed searching for My Documents and nothing came up. What should I do Hi GiantSonic, Here are some things that may help: 1. Did you recently install Desktop Search If so, WDS may not have finished building the search index yet (this can take a few hours). This is especially true if you’ve been using your computer quite a bit since you installed the product. You can check on the status of your index by right clicking on the WDS icon (magnifying glass) in the system tray and sele ...Show All

• SQL Server How to retrieve data from query and link the data to a data number?

  i'm doing a project on SQL Server 2005, i'm stack in searching the data and can't link the data in the data number.. can someone help mi with the programming code as i can search for the words in the table but i can't link with the data number.. first thing is how to search the keywords from the tables Second thing after u search the result ,how to link the result to a number related to the result ...Show All

• Visual Studio Team System Parrallel builds conflict over code coverage

  Hi, I have a single build server following continuous integration pattern where builds are kicked off by CheckInEvent's. In our case, we have shared projects on which a check-in will trigger multiple builds. The problem is that test execution has begun failing, rather Aborting, because of conflicts over the code coverage engine. Has anyone else encountered this BuildLog.txt message is: C:\Program Files\MSBuild\Microsoft\VisualStudio\v8.0\TeamBuild\Microsoft.TeamFoundation.Build.targets : warning : Code coverage collection error: Another test run has locked collection engine. C:\Program Files\MSBuild\Microsoft\VisualStudio\v8.0\TeamB ...Show All

• SQL Server Storing the ErrorDescription on DFT -> Flat file error output

  I have a Flat File Source that redirects bad rows to a DB Destination. I can Audit and get the ErrorCode (as well as an ErrorColumn, whatever that is ) but I need to save the error description as well. Is there a way to do this How Also, is there a way to email the error description / rows in the data flow task Thanks, Jason Hi Doug, How come, when you look at the error output in a data viewer, it contains an error description even though the error description is not in the metadata of the data path -Jamie ...Show All

• Visual Basic How to set the recordset of a classic ADODC (Data control) in .NET

  rst = goLists.Facilities 'function returns an open recordset Debug.Print( CStr (rst.Collect( "ID" ))) 'this ensure the recordset is really open! me.adoData.Recordset = rst 'error message occurs here Why does this give an error message saying that I need to initialize using the new keyword (or else check for Null before setting the object)  I have tried different variations of syntax, including putting this line first: Me .adoData.Recordset = New ADODB.Recordset 'but there is an error here too This simple operation (of setting a recordset on an ado data control) is something that I did all the time in VB6. What is ...Show All

• Smart Device Development ObjectDisposeException error

  Hi everyone!! I have create a program using VB.net.. In the main form, i have put a timer control to control the time display in the datetimepicker. The code goes: Private Sub TimerForDateTimeControl_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TimerForDateTimeControl.Tick Me.TimerForDateTimeControl.Enabled = True Me.DateTimePicker.Value = DateTime.Now Me.DateTimePicker.Enabled = False Me.DateTimePicker.Value = Me.DateTimePicker.Value.ToUniversalTime().AddHours(1).ToLocalTime() End Sub after i press logout button in main form, i hide the main form and open the login form.. and the ...Show All

• SQL Server XMLA and Deadlocks

  I have tested this on the RTM, SP1 and SP1+hotfixes and the problem is the same in all environments. What I am doing is using the "Analysis Services Execute DDL Task" in an SSIS package to execute different XMLA files. These files drop items in Analysis Services and then recreates them. What is happening is that in about one out of three times the package will hang at some stage in the process of running the files, Analysis Services becomes unresponsive and if I try to access anything in it using Management Studio it reports an error about a deadlock. It will remain like this until Analysis Services has been restarted. Note that ...Show All

• Visual Studio 2008 (Pre-release) Practical questions

  Hello all, For as far as I can see, LINQ offers key features that belong to the data access layer. (Not like the current features from System.Data in .NET 2.0.) LINQ is all about replacing existing data access layer code with LINQ code, I think. So is the true advantage that we don't have to write SQL code anymore If so, would the LINQ code be placed on the database server (stored procedures) or on the application side Would data access layers still exist And in what form Where would they reside On a (for example) SQL Server, or on the application side I could not find any 'best practices' yet on this subject. Hope you understand my issues ...Show All

• Visual Studio Team System News Groups

  Is there any newsgroup (private or public) on Team System Thanks Leticia ...Show All

• .NET Development Performance Counters

  We have VS 2005 Beta installed and all the .NET CLR REMOTING Performance Counter have been working. We upgraded to the VS 2005 by following the provided instructions. All VS 2005 items are working. BUT: Now the .NET CLR REMOTING Performance Counter are MISSING. How do I get them back I did a Repair of the .NET Frx 2.0 and that did the trick. Thanks...... ...Show All

• Visual C# No Overload Metod

  I'm using this cmd. foreach (String programas in rkey1.GetValueNames()) { ListViewItem item1 = new ListViewItem(programas, 0); item1.SubItems.Add(rkey1.GetValueNames(programas)); listView1.Items.AddRange(new ListViewItem[] { item1 }); } And it's appearing this error: No overload for method 'GetValueNames' takes '1' arguments c-ya, Miranda Try using item1.SubItems.Add(rkey1.GetValue(programas)); Otherwise, you already have the valuename in the programas variable so you would call item1.SubItems.Add(programas); ...Show All