sunil_sg's Q&A profile

• SQL Server replace out of range dates

  Hi, I'm migrating data from access 2003 to sql server 2005. An access table contains dates like 5/1/0999. This is a date that is out of the datetime range from sql server. Now my question is ... How do I replace these dates I don't find something like IsDate in the expressions Ok I did it with a Derived Column task. It replaces the date column values who have out of range dates. (It only checks for dates smaller then 1/1/1753) The expression is like this: [DateToCheck] < (DT_DATE)"1753-1-1" (DT_DATE)"1753-1-1" : [DateToCheck] ...Show All

• Visual Studio Express Editions Compatibility problem with MSVC++ 6

  Hello! I was using VC++ 6 with the library Allegro, without problems. Then I decided to try the Microsoft Visual C++ 2005 Express Edition, and installed it. After some tweaks, it compiled and ran my program. Perfect! However it doesn't come with MFC, so I had to go back to VC++ 6. However, when I tried to run the program (release or debug), it gave me the message "library file msvcr80d.dll not found, can't run the application". I tried to uninstall Express, nothing. Uninstalled VC++ 6, reinstalled, nothing. Why is the VC++6 trying to use the library from the version 8 Anyway, I went to another computer also with both VC++ 6 and Express Editions. To my surprise, the VC++ 6 said "library file alld42.dll not found, ...Show All

• SQL Server Migration exceptions

  Hi, How should one deal with exceptions generated by the DTS to SSIS conversion wizard in sql server 2005 Thanks ...Show All

• Visual Studio Express Editions how to print a Window form

  Please help me. Q: I design a window form in vb.net. that form drag and drop a labels and textbox. Now click a button(print) to print. Print window form inside labels and textbox. all contents prints. please help me. give a code. Thanks are you wanting to print the entire form as is if so, this can be done in a number of way but the easiest perhaps being to use the power pack kit... http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=903&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=747347&SiteID=1 ...Show All

• Visual Studio 2008 (Pre-release) Cannot import wsdl:binding

  When I run svcutil from the July CTP like so: svcutil https://webservices.netsuite.com/wsdl/v2_0_0/netsuite.wsdl I get the following error message: Error: Cannot import wsdl:binding Detail: The WSDL binding named NetSuiteBinding is not valid because no match for operation login was found in the corresponding portType definition. XPath to Error Source: //wsdl:definitions[@targetNamespace='urn:platform_2_0.webservices.netsuite.com']/wsdl:binding[@name='NetSuiteBinding'] However a code file 'NetSuiteService' still gets generated. I've been trying to diagnose the problem by browsing the WSDL by hand, and from what I can tell, there is a 'login' operation within the corresponding portType definition (it's the first operation that listed w ...Show All

• Visual C++ indexing

  how would i cache the names of all files and folders in C:\ Please include more details so that folks can help you. What are you exactly trying to do Are you asking for a general algorithmic question Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual Basic Key not valid for use in specified state.

  My ability to add data connections or data sources recently left. I cannot view a dataset in designer in previously created projects. I cannot create a new data connection in a new project. I don't know what's going on. I tried repairing the current installation. Then I tried uninstalling and reinstalling. Neither worked. Has anyone seen this before Neal After Googling, I found the solution: Delete the bad data connection (or ALL of them) in Server Explorer, and recreate them in Server Explorer. After I did this - VOILA! All my datasets reappeared and I was able to salvage the applications. ...Show All

• SQL Server Connection faileed Package abort

  Hello, I am connecting with various sqlservers in a package to get the information. If connection failed with any sqlserver, package failed after 3 tries. I would like that if connection failed with any sqlserver, package should not end rather move ahead and connecto next sqlserver. I already tried to increase the number of error from 3 to 1000 but still package failed as soon sqlserver connection failed. Any help is appreciated. Thanks. -- Farhan Many thanks, I will give it a try. You are the only who have replied, glad someone out there who knows and wants to help. ...Show All

• Windows Live Developer Forums Document's body height and pushpins....

  I have a frustrating problem. The map and the document's body height works great when used without pushpins... However, the document's height gets enlarged when you add a pushpin. This is creating a scrollbar that strangely goes away when you mouseover the pushpin. There is some code below that illustrates the problem. Does anyone know a hack around this Mayber there is a way to force a mouseover with a given pushpin ID Thanks, -Steve <HTML> <HEAD> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <script src=" http://dev.virtualearth.net/mapcontrol/v3/mapcontrol.js"></script > </HEAD> <script> var map = n ...Show All

• SQL Server Custom RollUp MDX Help

  Need help with MDX to add custom rollup for fact table with multiple grains. So the fact table will contain sales for the lowest grain, which is state, but may also contain sales for country. When navigating, if a fact record exists for the country, I want to display that value, if a fact record doesnt exists for the country, I want to display the aggregate the children of country. I'm looking for this to be dynamic so when the hierachy changes, but will take any suggestions... Fact Table TimeID GeographyId Sales Dim GeographyId ParentId Name Thanks - Joe ...Show All

• Visual C++ copy constructor compiler bug

  It seems to me that I found a bug in Visual C++ compiler. The thing is about copy constructor in context of throwing. As the Standard specifies [15.1 Throwing an exception, points 3-5] thrown object is copied to a temporary object. This temporary may be eliminated if eliminating it only removes a call to copy constructor and destructor for it. But removed or not the type of thrown object must be copyable (by constructor) and destructible (both functions must be accessible in the appropriate context) otherwise program is ill-formed. For testing I used Visual 6.0 (a little bit), Visual C++ 2003 Toolkit, Visual C++ 2005 .NET (both used with options /Wall /EHsc) and Cygwin (used with options -Wall). Here is the first bug. Lets consid ...Show All

• Visual Basic Referencing "ThisWorkbook" from a from in an Excel VB .NET Project

  I am new to VB.Net and have run into an issue I can't seem to resolve. I have added a form from which I need to access the "ThisWorkBook" object to my project. My Class definition for the form looks like this: Public Class frmLOVForm Dim wbThisWorkbook As Excel.Workbook = CType (Globals.ThisWorkbook, Excel.Workbook) When I run this I get the message in the immediate window: A first chance exception of type 'System.InvalidCastException' occurred in ExcelWorkbook1.DLL Followed by a dialog stating: The customized assembly could not be found or could not be loaded... (and in the detail section):Unable to cast object of type 'ExcelWorkbook1.ThisWorkbook' to type 'Microsoft.Office.Interop.Excel.Workbook'. Any ...Show All

• SQL Server SQL Express

  Hi: I'm trying to replace MSDE with SQL Express 2005, I would like to know if Window XP Pro SP1 is OK to use Can I write code with VB6 with SQL 2005 Express Any Step by Step Installation of SQL Express 2005 Thanks and regards Hi, you will need Windows XP SP2 for SQL Server Express: http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/RequirementsSQLEXP2005.htm The database engine can be called like the MSDE database engine. using ODBC you can use the SNAC client in order to connect. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Removing Duplicate Entries from a Parent-Child Hierarchy

  I have defined a Parent-Child hierarchy for one of my dimensions. (It is a flavour of organisation structure) However, when I process it, each node repeats itself as one of its own children. What is going on here and how can I fix this Someone mentioned a property I can set, but nothing jumps out at me. Handerson is right. You have the change the default property to get the desired effect. The default scenario which AS2005 is where a sales mgr and his salesmen all sell products and you wnat to display revenue for them. The alternative might be that only the salesmen sell and the manager does not have any sales, Then you ahve to reconfigure the property defined above. ...Show All

• Visual Studio Team System Install Workgroup edition now - Upgrade to full version later ?

  Just to confirm - I can install TFS workgroup edition for 5 developers initially (all with VSTS Developer editions), and when we need more than 5, I can upgrade to the full TFS edition at a later date There's no gotchas when it comes time to upgrade It's relatively painless. Instructions here: http://msdn2.microsoft.com/en-us/library/ms404848.aspx The biggest trouble people have is upgrading to volume licensing. Upgrading requires you to type a key, but volume-licensed copies don't have a key printed on them; you had to manually extract it from the disc. I believe that snafu has been ironed out by our sales team by now. ...Show All