SachinSurana's Q&A profile

• SQL Server Forcing 32 bit SSIS

  I have an Itanium 64bit server to run SSIS packages on. I have one package with three parralell streams. When I run the package in 64 bit mode using dtexec, it runs through validation and exits with no reported errors, when I run it from a job, the job fails and says to see job log, which has no errors. When I run it in 32 bit mode using the GUI, it runs all the way through. Does anyone know how to launch SSIS in 32 bit mode from a job on an Itanium Thanks Larry C I haven't used Itanium, but I suspect the following method will hold true- On a 64-bit version of SQL Server 2005, if you wish to schedule a package to execute a package under 32-bit mode, you will have to use the Operation System ( CmdExec ) job step type. The ...Show All

• Audio and Video Development Inserting a Ticker in the client data

  Is there a way that I can use the client data to pull a stock ticker across the bottom of the broadcast Also, is there a way to extend the length of the banner Thanks Try posting your question here: http://www.microsoft.com/windows/windowsmedia/community/newsgroups/WindowsMedia/default.mspx dg=microsoft.public.windowsmedia.server&lang=en&cr=US ...Show All

• Windows Live Developer Forums Unable to login to Windows Messenger 8

  Have been running Windows Messenger for years.....am now on version 8. Then last week .....it suddenly stopped signing me in. It has not given me a failed login message, it simply leaves the green and blue bodies spinning for hours on end. I can still access hotmail from internet explorer. The service report says it is running and stable. Any ideas Yes...can someone please explain what this problem is and how to fix it. I have been having this problem for a week now and its driving me insane. ...Show All

• Visual Studio Unable to debug: The binding handle is invalid

  When i try to debug a C# application I get this error: Error while trying to run project: unable to start debugging the binding handle is invalid What can i do Thanks for your answers This is sounding like some sort of DCOM/RPC configuration issue, but it is hard to know for sure. Luca, you said that you tried with attach, do you mean you tried with 'Tools->Attach To Process' Which part fails -- listing processes or attaching It sounds like everything is experiencing this problem for managed projects. Do you still have this problem for native projects How about attaching to a native project (example: notepad.exe) Thanks, Gregg ...Show All

• SQL Server Using "&" in a URL parameter field

  I have a report which has a field containing an "&" and I am trying to create a subreport off of this field which will show me the details for this one row. But when I click on the hyperlink, instead of passing this field to the subreport, it is passing the wrong parameters because the "&" is used as a field separator. Does anybody know how to avoid this I know that if I change the "&" to the ASCII "%26" that the subreport works correctly. However, I have tried using the Replace function and many other manipulations, but can't get the report Navigation link to automatically replace the "&". Any ideas Here is my exact code in the Advanced propert ...Show All

• Visual Studio Tools for Office Right Click Menu for Contact in OutLook 20003

  I wanna add one extra action once I Right Click on any Contact under outlook.... is there any hint Hi There is no support in Outlook 2003 through the Object Model to add a context menu on an explorer window. It is possible to try and do this through API calls but this is not supported and is full of potential issues. Regards ...Show All

• Smart Device Development ComboBox droppeddown?

  Hello, I tried to find how to know whether a ComboBox - sytle DropDown - has its list opened. For compact framework 2.0 I could not find an answer though there a several posibilities in .NET2.0 - but not for CF. Can someone tell me how to find out whether the list part of an DropDown-Combobox is open or not Thanks for all help. Jorg Hello, thank you. This might help. But I found an other way to solve my problem. I do not really have to know whether the combo box is dropped down. I ’ll keep yout code in mind for the next problem. Jorg ...Show All

• SQL Server How to filter with hierarchy

  Hi, I have a cube which has a "Relationship Hierarchy" dimension which is hierarchical. I have written the following MDX query which has a filter on the rows axis... SELECT NON EMPTY { Hierarchize({[Cost Centre].[L01 Cost Centre Name].members}) } ON COLUMNS, NON EMPTY {   FILTER(     Hierarchize({[Relationship Hierarchy].[Level1 Full Name].members}),     [Relationship Hierarchy].currentmember is [AXA SA]]     ) } ON ROWS FROM [MyMart] WHERE ([Measures].[Costs]) The query works as expected, but now I want to do something a little more advanced and I can't figure out how. I would like to have all children of 'AXA SA' returned too. So basically, I want to say this... FILTER(&l ...Show All

• Visual C++ text font clist ctrl

  how to change te text font in clist ctrl in mfc c++ Use a CFont::Create... function. Than assign the font with SetFont. Take care: The CFont object must exist as long as the child window exist. So best way to do this: add a teh CFont memeber variable to the parent window. ...Show All

• SQL Server Rounding a number

  Hi, I need to round a number in a table to either 2 or 4 decimals: =((Sum(Fields!Total.Value) -Sum( Fields!Total_used.Value))*100)/(Sum(Fields!Total.Value)) & " %" This results in a number like 91,1243656438345% I would like it to be rounded to 91,1244% or 91,12% Is there any builtin round-function, that does not just turn the number into an integer Thanks for your help You should be able to do this using the Format function =format(Sum(Fields!value.Value),"#,###.0000%") or =format(Sum(Fields!value.Value),"#,###.00%") ...Show All

• Visual Studio Virtual Directory Versioning Applications using ASP.NET 2.0

  Hi, I have a question, from the following website I found out that By default when you install ASP.NET 2.0 on a machine that has ASP.NET V1.1 already installed, it does not automatically upgrade these apps to use the new version. Instead, administrators get to choose which app uses which version. website: http://www.topxml.com/BizTalk-Orchestration/re-13231_Using-IIS-with-VS-2005-and-the-new-Web-Project-system.aspx but what if I want to make 2.0 to be the default option instead of 1.1. Can I do this programatically Thank you in advance, Chris Doloriert You are looking for the aspnet_regiis.exe tool in the .NET framework directory. You can specify the "version of the ASP.NET for a virtual folder(s)" i. ...Show All

• Visual C++ DLLMain defined in .obj file?

  Does anyone know if when you use the wizard to create a dll in visual c++, it puts the definition of DLL_Main in the Project_Name.obj file I get an error when I add in a definition of it in the cpp file, saying its already defined in the obj file. It's not in the cpp file when I first create the workspace. The wizard isn't creating the DLLMain entry point in the cpp file, but the calling program (in VB) still is able to call the dll function. I don't understand how this can work, and I am concerned that there will be problems with it down the road. ...Show All

• SQL Server Formulas for Column Properties

  I have a date column that has 1/1/1900 entries and I want to write a formula..(i think)...in the column formula section that when this date is encountered, the column should show NULL. I don't know the syntax to use in the formula section of the column properties. Can anyone give some syntax examples. Thanks Hi, if you want to store 1/1/1900 but just display NULL you should consider using a view or a query to decide on the value. If you want to change the data upon insert in the table, you should consider a trigger to change the data on the events like update / Insert to change if its a 1/1/1900 to NULL. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server InvalidReportServerDatabaseException RS 2000

  After upgrading to SP2, I get the following errors while tying to access the report server: aspnet_wp!library!160!11/16/2006-15:04:07:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.6.43'. The expected version is 'C.0.6.54'. To continue, update the version of the report server database and verify access rights., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.6.43'. The expect ...Show All

• SQL Server Multivalued Parameters

  Hi, In my report i have to display the dynamic columns i.e we have to display the columns available to the user user can select what columns he want in the report.In SQLSERVER reporting services there is no Check box filed,thatswhy iam displaying available columns to the user in a parameter named "Columns" and marked that parameter as 'MultiValued'. In the report body for example i have CaseID,age,Date columns,For CaseID column Visibility:Hidden-> iam writing the following expression,=IIF(Parameters!Columns.Value(0)=TRUE,False,true),and for Age column Visibility expression is=IIF(Parameters!Columns.Value(1)=TRUE,False,true).When i run the report iam getting this error:Index out of bounds.Why iam getting this error. ...Show All