Daniel Puzey's Q&A profile

• SQL Server SSIS Script Task and Other Assemblies/DLLs

  I am developing a Script Task for my SSIS package to transfer a file via FTP over SSH (SFTP). I have a nice set of Assemblies/DLLs (purchased from IP*Works) that gives me the added functionality of SSH. To even get Visual Studio for Applications to see it in the reference list, I copied the DLL (nsoftware.IPWorksSSH.Sftp.dll) to the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 directory, added it in the references for the script, and added the Imports nsoftware.IPWorksSSH.Sftp line in the script. As described in: http://sqljunkies.com/WebLog/knight_reign/archive/2005/07/07/16018.aspx Yet, when I try to run the SSIS package I get a ...Show All

• Visual Studio 2008 (Pre-release) Editing XAML - am I missing something ?

  I have the latest release, AFAIK, and Cider is useless - I cannot type into the XAML editor, and using the drag and drop is a waste of time. Expression is a ton better ( read, it can be used ), but is missing the most basic features ( how about search, let alone search and replace, or auto indent of XML, or even being able to use TAB to indent a section of XAML ). I realise it's pre-release, but surely the code for those common features is trivial enough to be put in early and make the tool useful Or are they there and I'm just too dumb to find them Cider is a great tool but have some issues sometimes. But there is no problems ...Show All

• SQL Server Trigger on System View

  Hi, Is there a way to create a Trigger on the Systemview [sys] . [dm_exec_connections] The Statement below Fails. CREATE TRIGGER [dbo] . [TG_CLEAN_LOCK_ID] ON [sys] . [dm_exec_connections] AFTER DELETE AS I need a trigger to be fired when a Connection ([sys] . [dm_exec_connections] .[connection_id] ) drops. Is it principally impossible to create a trigger on a system view or is it just a lack on permissions making my SQL fail Is there any other way for surveying wether a connection is alive or not, without polling Thanks in advance Raimund Meanwhile ...Show All

• Visual Studio Express Editions about rich text box so i will ask once more! please help!!!!

   thanks for any help just want (in Windows ) the person who opens a text file -that it will open with my note pad type program not windows notepad,     no answer so i will ask once more! can some one please tell me how to click a text file and get it to open with my vb notepad program i use file open with my program bt when my program opens the rich text box is empty   Dim MyFileStream As New FileStream( FilePath , FileMode.Open) RichTextBox1.LoadFile(MyFileStream, _ RichTextBoxStreamType.PlainText) MyFileStream.Close() ----------------------------- file path is the text file they ck so how to ...Show All

• Visual C# Which data structure should I use?

  I want to use a data structure in memory that models a many-to-many relationship. For example, one URL links to many other URLs and is linked from many other URLs. I envision this like a database table with two columns, linksto and linksfrom , with a compound PK on both columns. This allows me to get all the URLs a page links to by querying the linksto column, as well as all the pages linking to it by querying the linksfrom column. But I don't want to use an actual database. The simplest answers seem to be either an ADO disconnected DataTable, which I could filter using .Select method or an XmlDocument, ...Show All

• Windows Forms How to set the icon of a specific node in a treeview control?

  I have a treeview tvwmain and i want to assign different icons to the child nodes, how do i do that please help. thanks in advance. i've tried: this .tvwMain.ImageList = this .img; tvwMain.Nodes[0].StateImageIndex = 0; tvwMain.Nodes[0].SelectedImageIndex = 1; tvwMain.Nodes[0].Nodes[0].StateImageIndex = 2; tvwMain.Nodes[0].Nodes[0].SelectedImageIndex = 2; but failed, the the nodes' icons are set to ImageIndex 0. ...Show All

• Windows Forms posted this once and no replies... PLEASE HELP!

  Howdy everybody!   I was wondering, is it at all possible, to create a Windows Application, install it on two different computers, and using an IP address connect the two computers over the internet, and have one of them save an XML file on the other   Is that possible with the .NET framework Thanks! QUOTE: "I was wondering, is i ...Show All

• SQL Server source database information

  Hi, Yet another question. Where do reports store information about connection strings to their source databases and credentials that are used to access those databases. So far I have only found that report rdl file contains info about data sources, but it's in format: <DataSources>    <DataSource Name="ExperimentSource">       <rd:DataSourceID>xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx</rd:DataSourceID>       <DataSourceReference>ExperimentSource</DataSourceReference>    </DataSource> </DataSources> where the ...Show All

• Visual Studio Team System Installing without AD? Using ADAM? (Error 32000)

  I followed the instructions for installing TS to the letter, but when I try to install it on the application server, I get the error: Error 32000. The commandline "C:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\BISIISDIR\bisdwserver\bin\SetupWarehouse.exe" -n -s "SERVERNAME" -d BisDWDB -c "C:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\BISIISDIR\bisdwserver\bin\Consolodated.xml" -a "DOMAIN\TFSSERVICE" -v -l "..local..\Temp\SetupWarehouse.log"" returned non-zro value: 3. If I check the LogFile, it says: If exists(select name from Sysdatabases where name='BisDWDB') begin exec ('alter database [BisDWDB] set ...Show All

• Windows Forms Application Files

  Just wondering exactly what files do (or don't) appear in the Application Files list Cheers, Michael Weinhardt I have seen .net dll's, any data/config files which are built along with the application and copied to the bin folder, and com interop dll's. The com dll's are not shown btw, I guess someone from the clickonce team will know what are the exact type of files which are popped up.    ...Show All

• Visual Studio 2008 (Pre-release) BindingExpression with XPath='Profiles/Profile' cannot bind to non-XML object

  I am getting the most unusual error message and have no idea what it's about. In my code, I create a new XmlDocument, then I get the viewModel referenced below and set its Document property to my XmlDocument. On startup, I get this error: BindingExpression path error: 'InnerText' property not found on 'current item of collection' ''null''. 'BindingExpression':Path='/InnerText'; DataItem=''null''; target element is ''ListBox' (Name='profileListBox')'; target property is 'NoTarget' (type 'Object'); But, the listbox seems to work ok and displays my content as expected. However, if I add a new Profile element, create a new document, ...Show All

• Visual C++ _kbhit() memory uasge

  Hi, I've noticed that _kbhit(), and kbhit() too, use an abnormal considerable amount of memory. Same problem also whit  this simple code....     while( !_kbhit() )     {          //do something...     } pier! Actually, I have found in the latest sources that this has already been fixed. This should not be a problem in the latest builds of VS2005. Thanks, Nikola ...Show All

• SQL Server SSIS Programming Examples

  I have been creating SSIS packages programmatically and have run into somewhat of a dead end. I have found the examples provided with the SQL 2005 install very helpful, but they only cover setting up three tasks: Sort task, OleDB Source and a Flat File Destination. Does anyone have any examples or knows of examples of using the Merge Join task and the Conditional Split task I'm doing it all programmatically and so far I'm having trouble finding much in the way of documentation or examples. Any help would be great! Thanks, Mark I have been building packages programmatically, too. Sorry, b ...Show All

• Visual C# VS.Net 2005 hangs on a using command

  Ok, here is the problem   We’ve got the latest VS.NET software developer from MSDN (3 days ago), and in the past 3 days we were able to convert the entire project to .net 2.0, and getting it to compile and run.   The performance of the IDE is not good, but that is another thing to complain about, I can live with the poor performance, but not with the crashes.   I just realized that I cannot open any file that has the word: using MyProjectDataSets;   Well, this project has 4 large datasets (each of them 100,000) lines of C# code, cannot split the datasets because this is an InfoPath schema file, and the ...Show All

• Visual Studio Team System Test Result folder

  Hi, I would like to know if I can delete files in Out and In folder under Test Result folder, all information about test result is stored in trx file. Can I simply delete files and then publish trx file I dont need a big additional amount of data into build drop location. Is it possible Thanks, Tomas Hello, So, to be able to publish you are going to need the .trx file and the deployment directory. You can delete the "In" and "Out" directories that exist in the deployment directory (with all the files that live in them), but the deployment directory itself has to live there (I know this may not make sense, but ...Show All