David Sadler'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 from the Header Rec. to the Flat file destination first, then I need to write the multiple rows of d ...Show All

• SQL Server Still Getting computername\Guest error

  Thanks for the responses but I'm still getting this error. computername\Guest. Simple Filesharing is OFF on the xp server maching. My lap, where I wrote the app i'm using that connects to the server works OK..I connect after intering the computername\sqlexpress, dbname, username and password. But on another laptop I'm still getting error that shows computername\Guest. I can't figure it out. the only difference I see in the user accounts on both laptops is that under "manage network password" mine show only one entry "passport.net" where the other laptop(where I'm having trouble connecting) show two entries 1.email account and 2 passprot.net. I'm using sqlserver and windows authentication. ...Show All

• Windows Forms unable to find dependency

  Hi I have a vb.net 2005 app & accompanying setup and deployment project. One of the dependencies is VSTO - since I upgraded to VSTO - for Office 2007, now when I build my project I get the following errors: Warning 7 Unable to find dependency 'MICROSOFT.OFFICE.INTEROP.SMARTTAG' (Signature='71E9BCE111E9429C' Version='11.0.0.0') of assembly 'Microsoft.Office.Tools.Word.dll' C:\dev\ardex\premierV6\Ardex Premier Installer\Ardex Premier Installer.vdproj Ardex Premier Installer I have Office 2007 installed, and have 'refreshed dependencies' in the project. What next Thanks bruce I have the same problem. VS 2005, VSTO 2005 SE, Office 2007. The error makes sense in a way. It wants vers ...Show All

• .NET Development Interop unmanaged memory handling

  Hi, I am currently doing some Interop experiment and would like to know how to manage the memory allocated in unmanaged code. For example, for the following code, how can I free up *b == vcdll.cpp ======================================================== #include <windows.h> extern "C" __declspec(dllexport) void myTest(LPWSTR a, LPWSTR *b) { *b = new WCHAR[128]; wsprintf(*b, TEXT("Good %s"), a); } == Form1.cs ========================================================= using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Runtime.InteropServices; namespace VCS { public partial class Form1 ...Show All

• SQL Server Visual Studio 2005 gets stuck on Save or Preview of Report

  Hi all, I have a .rdl with a dynamic query that takes like forever to preview or save. The DataSet used for the report uses a dynamic query (starts with '=') and contains about 15 Iif statements that conditionally concatenates the query together based on the available 11 (report) parameters. The DataSet returns 18 fields. Has any seen this behavior before I left my machine on over night and in the morning VS was still at it! Thanx, -- Marc Jacobi ...Show All

• Visual Studio Express Editions Getting an Error when I use the Backspace to clear a textbox

  Hey all, When I test my code out, enter a number then backspace all the way back to the beginning i get an InnerException error. Here is the code that is throwing the error: Private Sub txtSequenceNumber_TextChanged( ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles txtSequenceNumber.TextChanged Dim SequenceNumberSelect As Integer = CInt (txtSequenceNumber.Text) Sequence2 = SequenceNumberSelect End Sub Above this I have a keypress event that spots the backspace....but I still get an exception when I backspace and lcear out all the numbers. Thoughts, Ideas, Links Thanks yes just as I thought from the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. My 2D particle engine now available

  here > http://www.codeplex.com/Wiki/View.aspx ProjectName=mpe Here be my first contribution to the XNA community, a fast, powerful & flexible 2D particle engine that can easily & seamlessly integrate into your game project. Features: Completely drag & drop, no code required! Complete control over scale, alpha, rotation and color at all stages of a particles life. Definable random variation of particle speed & lifespan. 5 emitter shapes - Point, Spray, Circle, Ring & Spiral (more to come!) Extremely easy to add custom emitter shapes! Hope you find it useful, there's still a few things to iron out but i think it's near enough usable right now :) Jeff Johnson wrote: ...am I just totally missing it ...Show All

• SQL Server Search for data inside a Recordset Destination

  Hi there, I need to develop a module and wondering what would be the best implementation... I get a list of files from a text file and store it in a Recordset Destination (object variable "CUST_INV_LIST"). I need to check that all the files in a directory are in the list. I can loop through the files in the directory using a ForEach container, but how do I check if it is in the CUST_INV_LIST recordset I thought about using another ForEach container to loop through the recordset, check if the physical file is equal to that row, if so set a flag, ... but it's neither elegant nor effective. Another option would be to use a Script Task to search for the physical file name in the recordset. I tried with the Data.OleDb.O ...Show All

• Software Development for Windows Vista Workflow templates

  I have installed/reinstalled the (on a XP SP2, VS 2005): .NET Framework 3.0 Runtime Components, Windows SDK, Orcas .NET Framework 3.0 Development Tools, Visual Studio 2005 Extensions for Windows Workflow Foundation and I still don't have the workflow project templates, and the workflow tab in the toolbox although I have winfx project templates and coresponding tabs in the toolbox, and intellisense works on workflow namespace. What shall I do I am having the same problem. I do have the VS Extensions installed and yes it does appear under Add/Remove programs. Something else is amiss here ...Show All

• SQL Server "Synchronize Connection Strings" Dialog box with XML Config file

  Hello, This has been happening to me since I started using Configuration files.  I use one XML config file that stores Machine Specific settings and one connection string to my Metadata database.  The problem is the database connection. When I set the conection in the Configuation file, save, close and reopen the package, a dialog box opens with the title "Synchronize Connection Strings". To reproduce the problem: 1. Ceate New SSIS Project 2. New Data Source Localhost.Adventureworks 3. In Package.dtsx  create an New Connection from Data Source... 4. Choose AdventureWorks 5. Save Package 6. Close Package 7. Open Package There is no problem at this point. 8. Enable Package Configurations 9. Create a new XML C ...Show All

• Visual Studio 2008 (Pre-release) Suggested Refactoring: Promote Anonymous Type

  Hi I've been playing with some of the ideas around anonymous types and one of the obvious limitations is that they cannot be used outside the local method scope. The suggestion is that if you want to do this the developer should create a proper type to be returned. The thing is the compiler/VS already knows what this type should contain, at least as a starting point. I propose you add something along the lines of promote anonymous type to concrete type refactoring. Implementing this feature will essentially save on work that would otherwise be fairly repetitive and similar. What do you think Kind Regards Duncan This is a good suggestion. We've actually prototyped a version of this refac ...Show All

• Visual Basic Unicode data in Jet 3.0 DB

  Hi All, I'm trying to extract some values form a Jet 3.0(maybe lower) DB created by a tool called Microsoft LocStudio. It has a .edb file extension. The columns I'm trying to pull seems to have characters encoded in Unicode, they don't show up property in Server Explorer. Using oledatareader I'm still able to read them as strings but they're truncated(probably because of the null byte), I've also tried to use Encoding.GetBytes(), it seems to work as long as the characters are in ascii, but once it hits foreign characters some chars does not display properly. Has anyone worked with this kind of file before or does anyone know a way to access the fields as raw bytes(i.e without any conversion from the engine, DataReader.GetByte() didn't w ...Show All

• Software Development for Windows Vista Problems incorporating WorkflowCommitWorkBatchService

  Hi I'm currently building a state machine workflow with the OOB web service activities.  I'm using the OOB persistence service and i'm also saving information into a custom data model.  To ensure the consistency between the workflow state and the custom data model I am following the work batch approach.  This works fine however I have the following problem with this arrangement. The problem is that I want to let the client using the web service know if there were any problems commiting the work, ie: I want to give them back a soap exception indicating any failure.  Is this possible using these standard activities and services Just as an example of the problem, I found this problem when I moved my source to a ne ...Show All

• Visual Basic how I can get the name of last event in VB.NET?

  Hello, I need to know how I can obtain the name of a current triggerred event in a such code: Private Sub dene(ByVal sender As Object, ByVal e As EventArgs) _ Handles btnOne.MouseHover, btnTwo.MouseHover, btnTwo.gotfocus, btnTwo.lostfocus Dim clickedCtrl As Control clickedCtrl = DirectCast(sender, Control) lblDisplay.Text = clickedCtrl.Name ‘.... name of the control ........ ' ----here I need to know where come here, for example from gotfocus of btnTwo or lostfocus of '....btnTwo in the list of Handles keyword. End Sub Could you please tell me about how I can get the name of last event in VB.NET Thanks nuranozcanli@bil-kay.com Nuran If it is neccesasary to know the calling event then I would suggest breaking ...Show All

• Visual Studio Express Editions Is this a bug?

  Here's the code that fills the ComboBox For i = 28 To 167 cmbSelected.Items.Add([Enum].GetName(GetType(KnownColor), i)) Nex t Here's the code to display the items in the Combo Private Sub ComboBox1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmbSelected.TextChanged Label1.ForeColor = Color.FromKnownColor(cmbSelected.SelectedIndex + 28) 'TextBox so I can see what's happening TextBox1.Text = cmbSelected.SelectedIndex End Sub If I click on the Combo and enter the first color, Alice Blue, then move down using the down arrow on the keyboard each color is diplayed right down to the last color YellowGreen. When get to the last colour and keep going it loops around and the colours no longer m ...Show All