awparran's Q&A profile

• SQL Server Corruption of package?!

  I have done this twice - grrrr! Simple SSIS package contains the following tasks Control Flow 1. VB .NET Script to create a file name with "sometext" + mmddyy + ".xls" 2. FTP Task - logs into FTP site, finds file name created in 1) and downloads 3. Data Flow Task Data Flow 1. Excel Data Source - connects to and maps the Excel workbook/sheet columns 2. OleDB Destination - Inserts rows using the column mappings from 1) abov ...Show All

• Visual C++ warning C4996: 'foo' was declared deprecated

  It appears that several standard C and C++ functions have been 'deprecated' in this version of compiler. This is a major annoyance since neither C nor C++ standards seem to mention this.  Naturally, it is possible to disable unwanted warnings, however doing this manually for every project is a pain in the arse. Is there a compatibility mode Thanks, - NK This is a request for future versions of c and c++ ...Show All

• SQL Server Cannot run job created by SMO

  I've create a SQL Agent job using C# SMO to process an Analysis Service Database (see code below).  When I tried to start job from Management Studio, I get the following error message...any ideas TITLE: Microsoft.SqlServer.Smo ------------------------------ Start failed for Job 'Schedule Job OLAPProj'. For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1314.00&EvtSrc=Microsoft.SqlServer.Man ...Show All

• Smart Device Development reset the activesync 4.1 using VC++ 6.0.

  Hi, I am developing ActiveSync service using VC++ & eVC++ . I need to reset the activesync 4.1 using VC++ 6.0. waitin for ur reply. thanks, Jay Check the following link for right newws groups for Active sync http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=286724&SiteID=1 ThankS Srikanth Bogadapati ...Show All

• Visual Studio Express Editions Problems with authentication using VWD

  I am having alot of problems trying to setup authentication. I am using VWD and SQLExpress 2005. I was following a tutorial and managed to get a user created. When I attempted to login I always get failed. There is no way that I can see to debug this. If there is a problem would it not be usefull to the developer to know what the problem is. I understand why the control will not indicate to the user what the problem is but when debugging I would ...Show All

• Visual C# PGP encryption using Visual Studio 2005

  I want to encrpt a text file using PGP encryption. Can anyone help Try to find on codeproject.com or codguru.com . I 'd seen this problem solved there. ...Show All

• SQL Server How to publish reports to production environment?

  I have a quick stupid question...I am using SQL Reporting Services 2000 and have designed a couple reports that I would like to publish to the production environment.  Only problem is that they do not have Visual Studio.  Is it possible to package and send them an installation routine for them to deploy Yes, you can do without IDE. Refer rs.exe commandline provided with SQL reporting server (setup ). ...Show All

• SQL Server Stored Procedure Problem - Couldn't find forum specifically for SP's

  Help me please. I have created a stored procedure and I'm not sure where I am missing the syntax problem. I am fairly new to SQL and have tried to research this problem and cannot find anything helpful. Basically I have to pick the results from the same tables but have a trigger of "hotel" and "not hotel" basically. I have to have one record return that pulls from two records in the same table. I think I have a major probl ...Show All

• Windows Forms DataGridView and posting changes to DataTable

  This problem appeared many times on this forum but in my case none of the solutions worked. The story is that changes do not appear in DataTable. dgv is bound to a dataset and DataMember has been assigned to a DataRelation (by its name). It views data fine, but when I type anything in dgv I can't see changes. I'm handling events TableNewRow and ColumnChanged. Those events are raised as they should when I change/add rows on dgv. When ...Show All

• Windows Forms How to handle Ctrl-Drag on design surface?

  Hi, We've got a custom designer working, we can drag items from our toolbox onto the design surface without any problem. However, we want to handle dragging while holding down control - this should create a copy of the control. When ctrl-dragging, the icon changes to a + to indicate that this is what it's going to do, but on releasing the mouse, nothing happens! The MSDN magazine example from March 2006 has the same 'feature'. Wha ...Show All

• Visual Studio Attach to HTML editor's drag n drop events?

  I'm looking to add some custom toolbox items that do a text insert into the currently open document in the HTML editor. So I'd like to intercept the drag n drop events that would otherwise be received by the HTML editor's control. I'd manually handle implementing the custom toolbox drops and pass on the default ones. Since there's no (documented) api to do this, I search around and found a thread trying to get the caret positio ...Show All

• Visual C++ How to detect lost Windows Network connection?

  I have established a connect and disconnect functionality using the WNetAddConnection2 and WNetCancelConnection2. Everything works fine and I can detect and cater for the errors whenever they occur with connection and disconnection. The problem came when I wanted to add a function to detect whenever a connection is lost, and attempt to reconnect. I've reviewed the msdn library ...Show All

• Visual C# Error while trying to compile website with multiple projects

  I have a website project that contains 4 seperate projects (ASI, ASI.ASIBasePage, ASI.DataAccess, ASI.Framework) and I have added the references to each of these in my project as well. The project was working fine until today when I changed a line of code in the DataAccess object and now when I try to debug, it gives me the following error: In a MessageBox, this appears: Source File: C:\Projects\ASI.DataAccess.cs Module: C:\Windows\Microsoft. ...Show All

• SQL Server CREATE ASSEMBLY failed because method 'UpdateVersion'

  I'm working on a CLR Stored Procedure and have code that builds using Namespace: Microsoft.SqlServer.Dts.Runtime Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll) When i try to create the assembly i get this: CREATE ASSEMBLY failed because method 'UpdateVersion' on type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageVersionUpdate90' in safe assembly 'Microsoft.SqlServer.DTSRuntimeWrap' has invalid att ...Show All

• Windows Forms NET Application Updater Component

  I'm trying to use the NET Application Updater Component. Is it possible to use this when you create a setup up project and deploy your application with a MSI file If so, how do you do it Yes it's possible, you just design&nb ...Show All