Anupam Pathak's Q&A profile

• SQL Server SSIS and SQL Agent is WORTHLESS

  I have an SSIS .dtsx package that will run fine during debugging, however, when I run it as a job under the SQL Agent the job won't start. To be more specific, the Agent will load the package, ensure that it passes validation (which it does), then sit there without starting the rest of the package. The job will run under the "executing" status until I stop it manually. Does anyone have any idea why it might be doing this I have logging enabled. However, the package never "starts" so the log doesn't pick up any errors. I have narrowed it down to an OLE DB transform I have (through the process of elimin ...Show All

• Windows Forms Accessing the row after a call to AddNew

  I'm using VB2005.  How do I access the row created when using the new button on the Binding Navigator.  I have to add some default info into some of the columns before the EndEdit is called.  Thanks Mike I found the following code in another Forum answer (can't now remember which), which does the job for me. My problem was not being able to create an object of the correct type to then add successfully to the BindingSource. The first couple of rows shows how (though not particularly intuitive!) Private Sub ProblemsBindingSource2_AddingNew( ByVal sender As Object , ByVal e As Sys ...Show All

• Visual Studio Tools for Office VSTO Install

  I installed VS 2005 but I do not see VSTO anywhere. Is this supposed to be installed along with 2005 Is there a place to download it Visual Studio Tools for Office is not included with Visual Studio Professional. VSTO is a separate version that includes a full development environment. You can find out about to buy VSTO here: http://msdn.microsoft.com/office/understanding/vsto/default.aspx However, VSTO is included with the Visual Studio Team System products. Harry Miller Technical Editor http://blogs.msdn.com/harrymiller This posting is provided "AS IS" with no warranties, and confers no ...Show All

• Visual Studio Express Editions my first program

  hy ive made my first program today after watching some of the videos on this site. Now i made a calculation program and it works fine until u type in numbers that deal with a , . like 0.00675. first my val1 and val2 were integers so they cant have , so i maked then double. but it still dont work. heres my code for the calculate button: Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'make vars val1 and val2 Dim val1 As Double Dim val2 As Double Dim opr As String 'set vars val1 and val2 and opr equal to te ...Show All

• SQL Server Error copying databases in SQL Server 2005

  How does one copy databases in SQLServer 2005 I am trying to copy a database from one instance of SQLServer 2005 to another instance of SQLServer 2005 using the SQL Server Management Studio Copy Database Wizard. The source database is a continuously updatable database, while the destination database is used for reporting purposes. When the wizard tries to create a SSIS package (as part of Copy Database), I get the following error: While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80004005 ([DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.) The details have additional message: ----- ...Show All

• Visual Studio Express Editions Can't download

  When I try and download "Visual Basic Express" I go through the setup, then it calculates the speed, at 0kb, and then does nothing. I already tried turning off my firewall and still didn't work. What can I do I have now tried and disabled the antivirus, and I could download .net 2.0 but not visual basic. you can download a copy from http://msdn.microsoft.com/vstudio/express/support/install/ ...Show All

• Visual C# Why is this variable not visible?

  Clip of my code:             // Begin the WebRequest to the desired WEB address             WebRequest myRequest = WebRequest .Create(URL);               try             {                 // Attempt web connection               &nbs ...Show All

• Visual Studio Changing database login info at runtime VS05 RTM vs VS05 Beta 2

  I've a group of reports developed with Crystal 11 that need to have their database connection information changed at runtime.  I'm following the sample code pattern for integrated security with winforms.  With VS05 Beta 2 this all worked just fine.  With VS05 RTM if the runtime database connection matches the report connection everything works fine.  If the runtime connection is to a different database I get an error that seems to indicate that the Re portDocument.DataDefinition.ParameterFields values aren't being read correctly. Has Crystal functionality changed from Beta 2 to RTM   Is the sample code wrong for the ...Show All

• Visual Studio Team System Using Unit Tests to drive the Profiler

  I have several operations that take a long time, and I'm trying to determine what exactly the bottleneck is. I have created tests using the testing infrastructure that allow me to run the same operation over and over, so I can see trends in how long the operation is taking. What I really want to do is have the Profiler run while the Tests are running, so that I can figure out what portions of the code are taking a long time. So far, I can't figure out how to do this. How can I maket his work -- Chris Mullins Hey Chris, Once you have run your tests and see the results in the Test Results window, try right-clicking on a single test.&n ...Show All

• Visual Studio Team System Get Custom Check-in Policy in the Add List

  Hello, I have a custom check-in policy that requires that the comment is filled in.  I added the assembly to the HKLM\Software\Microsoft\VisualStudio\8.0\TeamFoundation\SourceControl\Checkin Policies registry key.  The key is the assembly name, the value is the full path to the assembly. But the policy does not show up in the list   How can you get your custom check-in policies to show up in the list For reference, I used the folllowing post for guidance.  I derived from PolicyBase to create the custom code policy class. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=139563&SiteID=1   Thanks! Cindy ...Show All

• SQL Server Previous Row Calculations (sql server 2000)

   if anyone know a way that you can look up a value from the previous row in a View to do a calculation on (in sql server 2000) for example: expr1=PreviousRow.Expr1/30 + expr2 - expr3 =100 so the next row is expr1=100/30 + expr2 - expr3 =300 so the third row is expr1=300/30 + expr2 - expr3 =100 or tell me if it not possible please and special thanks to Umachandar Jayachandran - MS for help. the second line is the initial expr1: update #temp set pv = 0 where id = 1 ...Show All

• Visual Basic Turn off green coloring after filling out a snippet?

  Hi there Tryed searching for an answer 'cause I really cant understand that Im the only one that have this 'luxury' problem. Is there any way to turn off the green coloring after having filled out the snippet information other than closing down VS2005 Wow. Sounds nice. So now its just a question if our company will be moving to VS2008.. ...Show All

• Visual Basic URGEN~!! I cannot save data in vb.net

  Hi guys, I'm a new vb.net user and trying to add year with the numericUpDown. I used the same coding in other forms, it works. Only this form can't work. The error is pointing to syntax error in INSERT INTO statement. Can anyone help me sql = "INSERT INTO Year VALUES " & "('" & YOB.Value & "'," & "')"                 Dim cmd As New OleDbCommand(sql, con)                 Try                  &nb ...Show All

• Visual Studio Express Editions print image from resource

  Hi!!! I want to print a image to a printer. Actually I’m using the following : ev.Graphics.DrawImage(Image.FromFile("C:\MyPath\bitmap.bmp"), Rect)  where rect is a rect structure I’m searching a form to print the bitmap but from a resource Thanks for the help Here's how to do this if you've added the bitmap to VB's resource designer:   Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim gr As Graphics = Me .CreateGraphics gr.DrawImage( My .Resources.Image1, 0, 0) End Sub My.Resources.Image1 is a ...Show All

• Windows Forms Hosted Designer Smart Tags not showing up.

  I can't seem to get the Smart Tags to show up in my hosted designer. What am I doing wrong here is the service and options class class MyDesignerOptions : DesignerOptions { internal MyDesignerOptions() { this .GridSize = new Size (12, 13); this .ShowGrid = true ; base .UseSmartTags = true ; this .UseSnapLines = false ; this .LayoutMode = LayoutMode .SnapToGrid; } //public bool UseSmartTags //{ // get { return base.UseSmartTags; } //} public LayoutMode LayoutMode { get { Trace .WriteLine( string .Format("get_LayoutMode: {0}", layoutMode)); ...Show All