P47's Q&A profile

• SQL Server Script component to send email

  Is there a way I can on any exception, call my .NET code using System.Mail in SSIS 2005 and use my custom code to send emails rather than the Mail component   The mail component sucks, you can't change the look & feel of the email being sent using CSS but if I can fire off my own code to send the email, then that would work great.     To ensure your script task fails on any error, you would create an On ...Show All

• SQL Server Does a checkpoint file record a package's state

  The state of a package at any one point in time is determined by the values in all of its user variables as these are the only properties in the package that can be changed and persisted throughout the runtime of the package. Is the package's state stored in a checkpoint file in the event that the package fails In other words are the user variable values stored in the checkpoint file Thanks Jamie   Similarly, you coul ...Show All

• Visual Studio Express Editions Saving Text to an Excel file

  I have searched all over for this, and can't figure out what to do, could somebody please start from the top, and explain to me in depth exactly what I need to do to Save text to an excel file Using normal file appending doesn't ever change the cells, I need a more integrated way, so please explain to me what I need to do from scratch, as of now I have nothing on my project. -Thanks I'm assuming ...Show All

• Visual Studio Tools for Office Word Document Protection

  I've created a Word Template project with an XSD schema that has elements for users to fill in. The users will then upload the docs to a server so I can read some values from the ServerDocument cache and save the Node WordML. Somewhat similar to memo example on MSDN: http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_wd2003_ta/html/odc_wd11xml.asp I've added protection to the doc so that users cannot modify anything except t ...Show All

• Windows Forms How to convert a string into a datetime.

  I have a string value = "2004", which is from a listbox. How do I convert this string into datetime format I need this datetime format value to be a parameter to call other store procedure. I have tried this 3 codes and none of them& ...Show All

• Visual Studio Team System VSS Migration Error

  Unable to write to SQL Server: .\SQLEXPRESS due to Error: The size (4969) given to the parameter 'Mappings' exceeds the maximum allowed (4000). This popped up twice and prevented my migration from going through. You'll notice the link goes no where. So, any clues/suggestions on what to do next Thanks, Drew Umm, little help here Tryin' to migrate over by this weekend and this is currently the on ...Show All

• Visual C# import csv data into database

  Hello,   I'm a absolute beginner by programme asp.net with c#. I have to develop a tool, there I need to import some csv-files in the sql-database. I realy don't kown how to start. Can sombody help me, please thx Dabro   Thanks dabro for the reply! I'm glad you understand it now, please feel free to post whenever you have problem with implementing it! ...Show All

• Visual Basic Programming to Physical Comptuer

  Hello Once again, I need your help I want to know if there is a way that the programming that can affect the real physical computer such as the hard drive, motherboard, RAM, Power Supply, Drive Thank You! all answers to kn1123@gmail.com! "Affect" is always a funny word..... I have a very fast pentium whose base operating temperature is high, and when it's compute intensive it heats, alot. I can see it warming up during virus scans, for exa ...Show All

• Microsoft ISV Community Center Forums GroupBox Borders

  I have looked on the online help files and community discussions, but haven't seen this question come up... Is there a way to set the border of a Groupox similar to what Panel does Panel will let you set Border Style to 3D Fixed etc. This property does not come up for GroupBoxes. I have seen VB screens that clearly are using GroupBox since it includes a caption on the top border and have a 3D type of border on them. ...Show All

• Visual C++ Control Bracket Formatting

  I'm sure this has been asked numerous times, but it is a hard thing to search for.  Anyways, I am using Visual C++ 2005 Express Edition and it writes code like this: if () {    statement; }   I want it to write code like this: if () {    statement; }   How do I do this   Thanks a bunch. According to my knowledge, I don't believe there is a current ...Show All

• SQL Server "Send Mail Task" Error.

  I setup a "Send Mail Task" task and an SMTP connection objection. I ran the package and got this error: >>> SSIS package "Package.dtsx" starting. Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: "Failure sending mail.". Task failed: Send Mail Task Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised ...Show All

• Visual C++ Report Designer

  Anyone know how to get to the Report Designer in VS 2005 C++   Chicking on "Add" and "New Item" does not show a "Report" selection.  DataSet is there and the ReportViewer is in the Toolbox.  Am I missing something or have us C++ types been forgotten (again) Ronald Thanks for the reply.  I'm using the following version: 8.0.50215.44 (beta2.050215-4400) which was sent to me on a CD from Micro ...Show All

• SQL Server SSIS thinks an invalid expression is valid

  I have put the following invalid expression: @[Metadata ::ValidStream == TRUE (note the lack of a closing square bracket) into a precedence constraint, clicked the "Test" button and got the message "Expression validated successfully". Can anyone replicate this -Jamie Maybe an IDW16 issue. On IDW15 (all I have to hand) it fails as I would expect- Attempt to parse the expression "@[User::FF" failed.  The token "@" at line number "0", ...Show All

• .NET Development Remoting Call on Windows forms server

  Hi, I'm new in remoting and I need someone to clarify something for me. I have an windows forms app that serves as a socket server in VS 2003 accepting connections from clients via the internet. I want to build a class library that will be the business rules component. When a client sends a request via the socket, the socket server will have to call a function on the business rules component asynchroniously and when the processing is do ...Show All

• .NET Development ConfigurationSection Question

  I am in the mist of learning about the new configuration classes in the 2.0 framework. Here is what I am trying to do: Define my own custom section in the app.config Have the application read this custom section from the app.config Have the application be able to modify the values from this section Save these changes as a user config file From what I understand with the new configuration classes the flexibility is there to save ...Show All