mr4100's Q&A profile

• SQL Server SSIS Data Flow task fails to load all text from flat file

  Hi Guys, I have a flat file which is loaded into the database on a daily basis. The file contains rows of strings which I load into a table, specifically to a column of length 8000. The string has a length of 690, but the format is like 'xxxxxx xx xx..' and so on, where 'xxxx' represents data. So there are spaces, etc present in the middle. Previously I used SQL 2000 DTS to load the files in, and it was just a Column Transformation with the Col001 from the text file loading straight to my table column. After the load, if I select len(col) it gives me 750 for all rows. Once I started to migrate this to SSIS, I allocated the Control Flow Task and specified the flat file source and the oledb destination, and gave the output column ...Show All

• Visual C# C# and ASP .NET Documentation for beginners

  Hello. Where can I find a good documentation about C# and ASP .Net 2.0 on Msdn Any suggestion is welcome. I need to learn ASP .Net in two weeks. Thanks'. Okay, visit these links : ASP.NET QuickStart Tutorial ASP.NET Web Services QuickStart Tutorial Visual Web Developer 2005 Express Edition Guided Tour PS. Don't forget to set "I want my samples in" filter. ...Show All

• Visual C# 同 How to use c # to write shrinking algorithm?

  Algorithm use c # language is described shrinking Can write the code example thanks ----------------------------------------- 1: 0,1,9 　 2: 4,8,4 　 3: 7,3,3 　 4: 3,1,3 　 5: 7,3,6 　 6: 2,5,5 　 7: 4,5,9 　 8: 5,5,8 　 9: 5,0,4 　 10: 7,3,5 　 11: 1,9,3 　 12: 0,3,5 13: 5,5,0 　 14: 8,1,4 15: 9,1,6 //estimate next number through these datas --------------------------------- 16:( ),( ),( ) ...Show All

• Windows Forms datatable and dataset

  hi i have Private WithEvents dt1 As New DataTable Private WithEvents dt2 As New DataTable Dim ds As New DataSet now i add the two tables to my ds. can i do this...> dt1 references another table, dt2 same thing. imean i am not goind ds.tables("dt1") etc . . . is it not the same tables i am referencing Not sure I completely understand the question, but I did the following: Dim dt1 As New DataTable dt1.TableName = "Test1" Dim dt2 As New DataTable dt2.TableName = "Test2" Dim ds As New DataSet ds.Tables.Add(dt1) ds.Tables.Add(dt2) dt1 = New DataTable dt1.TableName = "Test3" MessageBox.Show(ds. ...Show All

• Visual Studio Tools for Office How to detect a new incoming email?

  Hi, I wrote some code but cannot work... private void ThisAddIn_Startup( object sender, System. EventArgs e) { Globals .ThisAddIn.Application.NewMail += new Outlook. ApplicationEvents_11_NewMailEventHandler (NewMail); } void NewMail() { Outlook. NameSpace outlookNameSpace = Globals .ThisAddIn.Application.GetNamespace( "MAPI" ); Outlook. MAPIFolder inbox = outlookNameSpace.GetDefaultFolder(Outlook. OlDefaultFolders .olFolderInbox); Outlook. Items unreadMailItems = inbox.Items.Restrict( "[Unread]= true" ); foreach ( Object mailItem in unreadMailItems) { MessageBox .Show( "Haha" ); } } Pls help me... Thanks Hi VSFW3, You code will only ...Show All

• SQL Server help?

  I need a little help to get me going. I have built a web app in visual web developer and made and inserted an sql db into the site with multiple .aspx pages. It all compiles and seems great. Info from the db is displayed,however when it comes to edit,  insert or delete it bombs out "   incorrect syntax near'nvarchar'  or on delete........'int'   some thing needs to be set to true... All conection strings seem fine and test ok. ps, whats the best way to to totally smash your dell laptop to pieces and send it to pluto Have included error Seems that the statements posted do not contain any information about nvarchar, so I guess this is related to any trigger based on the tables. ...Show All

• .NET Development HTML header in ASPX page

  Can anybody explain to me how to have a header/footer bar on an aspx page that will be added to the aspx page without getting in the way of the controls on the aspx page For instance, I am able to put the header bar on the aspx page but, If I put controls on my aspx page too high, they will show up in the header part of the page. So, at design time, I have to know to leave a space at the top of my page in order for the header to not get over-written. I am using this piece of HTML in order to write the contents of the .HTM file to the ASPX file at run time: < body bottommargin ="0" leftmargin ="0" rightmargin ="0" topmargin ="0"> <%Response.WriteFile( "PageHeader.htm&quo ...Show All

• Visual Basic copying a file to the root of a drive

  I am trying to use filecopy() to copy a file from my hard disk to the root of a USB drive and I get the error message "Could not find a port of the path 'e:\' any ideas thanks Your error is probably because you are not specifying the filename. The syntax, as per ahmedilyas' post, requires the pull path and file name for both arguments. ...Show All

• Microsoft ISV Community Center Forums Office Word Macro - create file to a specific directory

  I have a macro that automaticaly creates a Word file with a prefix sequential number and suffix. It saves the file to the "My Documents" folder by default. I want to be able to save the file to a different location but don't know how to do this. My knowledge of VB is limited. Any help appreciated. Her is the vb code: Sub Report() ' Automatically creates a new document in a sequentially-numbered order ' based upon the stored sequence number in MySeq text file ' Dimension the variables Dim strMyFileName As String ' Open MySeq file and load the sequence number MySeq = System.PrivateProfileString("C:\Documents and Settings\50065a.SCI\Application Data\Microsoft\Word\myseq.txt", _ "", "MySeq" ...Show All

• Visual C++ How can i make my editing auto completed?

  I use vs2005 to write cpp code A class is defined in a .h file, and I refer to this class in a cpp file including the .h. when I type "->" following a pointer of that class, no hint is showed about the members How can I make it work, thanks Make sure that the .h file included correctly and it's error free. Sometimes the intelisense database not updating properly. Do the following 1. Close the solution 2. Delete ncb file of the project 3. Reload the project. Hope it work. ...Show All

• SQL Server How to change configured value for the ServerName property of a Connection via DTEXEC

  I am launching a package the following way: DTEXEC.EXE /SQL "\ProcessReportingDatabase" /SERVER RTG23SQLDB01 /REPORTING V /SET "\Package.Variables[User::RunID].Value";35 /SET "\Package.Connections[RSAnalytics].Properties[InitialCatalog]";"Fnd Prj 1 Dec29" /SET "\Package.Connections[RSAnalytics].Properties[ ServerName ]";"RTG23SQLDB01\UAT1PROD" The problem does not happen with the [User::RunID] variable or the [Initial Catalog] property of my [RSAnalytics] connection object. But I am not successful in setting the [ServerName] property. What happens when executed is that the package retains the ServerName property of the deployed package (Value=" RTG23SQLDB01\UAT1QA & ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectX 10-Vista

  I owe a computer with W. XP.I'm going to upgrade it to Vista.My question is if directX 10 needs only Vista to run.My system is fueled by ATI radeon x1600 pro.Do I have to change it or just have Vista hmm, i'm not sure. Graphics cards have nothing to do with your processor. If the card fits in your pc it should work. If intell graphic cards would only work on intell based systems they would loose a lot of customers cause most gamers use AMD. Its just a brand. If the intell DX10 compactible card will be low budget i hope they work on AMD cause i have amd myself and a low budget for these kinda things :) ...Show All

• Windows Forms How do i prompt an error if different format is used...

  I building a software that can play movie file. How do i make an error prompt in C# Coz now i have a button that open a dialog box to choose movie file coz my program only can play movie so if let say a user open format other than a movie format..eg. mp3,.wma a messagebox will appear saying "this is not a valid movie format" something like that.. can anyone help my source code for the movie: //----------------------------------------------------------------------------------------// //Video private void button1_Click( object sender, EventArgs e) { // Allow the user to choose a file. OpenFileDialog openFileDialog = new OpenFileDialog (); openFileDialog.Filter = "Me ...Show All

• SQL Server Creating A tab delimited export

  Hello all, I am trying customize the CSV rendering extension with different device information settings. I would loke to change the CSV extension to a Tab delimited output. However, whenever I add a new extension line to the RSReportServer.config file I run into problems. 1. What is the correct character to use in the delimiter to specify a Tab character I seem to be unable to get this correct 2. Why when I override the name in the rendering extension does it still show up as the CSV (comma delimited) name in the export dropdown. Here is my customized rendering extension. < Extension Name = " TXT " Type = " Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRend ...Show All

• Visual Studio 2008 (Pre-release) Trusted Subsystem Implementation

  We are building an application that has multiple WCF services hosted in IIS on multiple machines within a customer's topography. The services need the ability to access network resources (hops to other WCF services, database, file system, and active directory). We have been treating public services as trusted subsytems: access to the public service is authenticated and authorized using the user's identity, but access to other resources within the service are executed under a trusted identity. Here is my question. What is the best way to access the other resources under the trusted identity Run the App Pool as Network Service and Impersonate when access to the resource is required. Seems kind of messy having to store the truste ...Show All