Garrett - MSFT's Q&A profile

• SQL Server Flat File with Nested Data

  I am looking to import data into SQL Server 2005 using SSIS. I want to take data that is contained in a flat file and place it into the various appropriate tables in my system. The flat file contains nested data. For example... Bob,Smith,555-5555,123~3.33|245~1.99,Active So I want to build a package that brings in the records as follows Client Table: First Name, Last Name, Phone, and Status (Bob, Smith, 555-5555, Active) Order Table: OrderID, Amount (ID 123 @ $3.33 and another row ID 245 @ $1.99). If possible I would also like to tie the orders to the client record that was inserted. My first question is if SSIS supports nested fields as in my example. Can it break a file by commas, then within a field by other delimiters I ...Show All

• SQL Server Bulk Insert performance

  I have a situation where I need to do multiple inserts into the sql mobile db at one time. I am wondering what would be the most efficient method to do this. Right now I am just doing many inserts, but the performance is lacking. I tried to wrap all the inserts into 1 sql command and process it like that, but it does not seem to want to execute. Any help would be appreciated. Form a loop to write the columns (tab seperated) in the order exactly as in the table in database using SteamWriter object's WriteLine() method. Code Block using System.Data.SQLClient; cnMessage=new SQLConnection("Your Connectionstring") string PathToFile="\\\\DBServer\\Messages\\File.txt" cmdMessag ...Show All

• SQL Server SQL Agent Roles

  I have a domain account that is assigned the the SQLAgentOperator, SQLAgentReader, and SQLAgentUser roles. That domain account is able to create a job and delete the job. But, it is unable to edit the job. If I create a SQL Login with these same permissions, it is able to edit the job. What am I missing We were looking forward to implementing these new built-in security roles because we had to use our own security roles to give us similar functionality in SQL 2000 but it doesn't seem to be working properly in 2005. Michelle Satya, The domain account that is in the SQLAgentOperatorRole is not trying to change the owner of a job that they own, they are trying to edit a step of a job th ...Show All

• Visual C++ Mutlitthreading of a C function in a C++ environment

  I have developed a GUI using Visual C++ and has linked up with the computation procedures that are in C style code. Everything is fine except that when the C functions are called, the GUI windows 'hang' as the function is computationally intensive. Therefore the windows info do not have 'time' to update. One of the method to circumvent this problem would be to use threading. I have read the MSDN website on threading and they focus only on C++ functions. This is the first time I am doing threading. How do I start a thread with a C function that requires a parameter The C style function is of the type- void compute(char *); As my function would end naturally, how would the main GUI program be aware of its completion Thanks. ...Show All

• Visual Studio Express Editions Find out which sub I am in..

  Hi folks, is there a way to figure out the name of a sub while inside it Like, in a form, Me.Name yields the name of the form For debugging I would like to create a message that, in case of an error, tells me what the error is and in which sub/function it happened. Ofcourse I can add the name to the error message by hand, but it would be more convenient. Example Select Case Err.Number Case 13 : MsgBox(Err.Number.ToString & " in CalculateEquivalentStress" ) <<< NOT Case 13: MsgBox(Err.Number.ToString & " - " & thissub.Name.ToString) <<<< something like this End Select Suggestions welcome! Thymen anubisasce ...Show All

• SQL Server I can't connect to http://localhost/Reports - rsinternal error

  After a new installation I can't connect to http://localhost/Reports - rsinternal error The logfiles give me the following: (haven't been able to find an answer to this issue) <Header> <Product>Microsoft SQL Server Reporting Services Version 8.00.1038.00</Product> <Locale>en-US</Locale> <TimeZone>W. Europe Daylight Time</TimeZone> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServer__07_28_2006_11_27_56.log</Path> <SystemName>BUIS8907-6</SystemName> <OSName>Microsoft Windows NT 5.1.2600.0</OSName> <OSVersion>5.1.2600.0</OSVersion> </Header> aspnet_wp!webserver!b0c!7/28/2006-1 ...Show All

• .NET Development Memory Consumption: Gdiplus::Bitmap vs. System.Drawing.Bitmap

  The msdn says System.Drawing.Bitmap is just a wrapper of Gdiplus::Bitmap, but I find there is a big memory consumption difference between these two classes. I created a Bitmap using both class from the same png file (resolution 2268*1700) VC++: Gdiplus::Bitmap* b =  Gdiplus:: Bitmap::Fromfile(_T("test.png")); VC#: System.Drawing.Bitmap b = new System.Drawing. Bitmap("test.png"); The VC++ version costs me 3MB memory, which is quite acceptable. The VC# version, however, takes up around 18MB memory, which really freaks me out. System.Drawing.Bitmap as a wrapper, I understand if there will be some overhead. But 5 times more memory is just miles above the red line. Could anyone tell me whether I'm using the Bitmap in right way Or any ...Show All

• Windows Live Developer Forums Live Messenger event IncomingTextMessage will not fire sometimes

  My Live Messenger addin event IncomingTextMessage will not fire when receiving data like zFIQQIoa+/iptI/oC6fUtg== But if I send data like 'hello' it does fire. Why is this ...Show All

• SQL Server Whats the difference between a dialog and a conversation?

  As above I guessed as much. BOL however uses the two as the same thing and often refers to the one as the other i.e. "a dialog is a conversation". Not sure what can be done, but I have found it confusing, you begin a dialog but end a conversation begin dialog returns a dialog handle, but end conversation takes a conversation_handle. Even though they are the same thing. ...Show All

• .NET Development application doesn't run in the other computer

  I have Visual Studio Professional 2005 at my office and Visual Studio 2005 Beta at home. When i make a simple C++ Windows Form Application in the office i cant run at home. I receive a message that i translate: "The application configuration is incorrect .Reinstall may solve the problem." If i open the project with Beta and i try to run without bilding i receive a similar error ,It says also "Review the manifest file for possible errors". I rebuild then and runs in both computers. The reverse problem doesn't happen. If a create a program at home runs in the office. If i have Net Framework 2 in both computers why doesn't run at home the first program Thank You. The p ...Show All

• Visual FoxPro Caps lock ON when application activate.

  Can I trap the 'activate' of my app I want to turn on caps lock every time the user selects the VFP application. I don't want to do this at the start of the app because the user may minimize the app and then get back to it. Thx. force capslock() = .T. check the status of capslock whenever some events occur and if capslock() = .F. U FORCIBLY TURN IT ON. DISPLAY A MESSAGE UR APPLICATION WILL NOT WORK WITHOUT CAPSLOCK ON. LOOP IS FORCE THE USER TO TURN CAPSLOCK ON, IF HE DOES'T DO THEN APPLICATION WILL NOT WORK. THANKS ...Show All

• Visual Studio Team System Team Suite and TFS Installation

  Hi, We have downloaded En_vs_2005_vsts_180_Trial.img, en_vs_2005_tfs_trial.iso for 180 days trial versions. Now we need information about installation of Team Suite/TFS. Which one should be installed first and how Sneh Sneh, you may refer to this blog on setting up Team Foundation Server. http://blogs.msdn.com/tolong/archive/2006/07/22/674690.aspx ...Show All

• Smart Device Development Deploying and accessing lots of images

  Hi, my application uses lots of images to display. Currently the user has to manually copy the data to his device and then specify the path to this. The data is stored in subdirectories, like \category1\image1 \category2\image1 \category2\image2 ... Now manually copying works, however it's quite uncomfortable. First idea was to make those files automatically copy by putting them in the .CAB file. However the CabWizard gives a build error. Searching the web revealed that the problem might be, that there are to many files (all in all around 2000 images, each around 5k). But even if this would work it's not a very elegant solution. The best thing would be to package all those images in some kind of si ...Show All

• .NET Development Connection String in Client / Server Application, Strong typed Dataset

  Sorry bout the subject, but it is my conundrum. I have a solution (C#) that is fat clients (winforms) talking to a database (SQL Server 2005). Our solution uses a strong typed dataset for all of its operation for the various benefits gained therein. I have used untyped solutions, and when you write the dataadapters, its very easy to customise the connection string. However strong typed, you must specify the connection string at design time. Our server deployment must be hands off, and thus my problem. I have created a customised database installer that obtains information entered by the Administrator on how to connect to the database, and I have a way to take that information and put it into a string. What I need is a writa ...Show All

• SQL Server SQL Chargeback

  Does anyone know of good chargeback software for use with SQL 2000 & 2005 We have two shared SQL servers with 120+ databases from various departments but cant find any off-the-shelf software which will allow us to produce MIS reports for mangement and charge back. I am aware of a Microsoft document however, this doesn't work too well and is too complicated for our maagement to use. ...Show All