Newbie Kam's Q&A profile

• SQL Server Calling Reporting Services from SSIS

  Hi I have created a packages which pull and push the data to SAP server. I want to create a report every day and send that report to the manager. For the same i want to call reporting services in my SSIS package. I know i can write a SQL script and export the report in excel but i want to use Reporting services. Have any one call reporting services from ssis. In SSIS  we can call/work on analysis within SSIS package by using tools which are provided in toolbox...  --ToolBox -- Control Flow Items -- Analysis Services Execute DDL Task -- Provides ability to process DDL query statement against Analysis Services. --ToolBox -- Control Flow Items--Analysis Services Processing Task -- Provid ...Show All

• Internet Explorer Development ActiveX installation for all users of a vista workstation

  I have a DLL and an OCX components installed in the Vista workstation under the following path with a cmd file, executed with 'RunAs Administrator' option. The simple command goes as follows RegSvr32 c:\ET\comp1.dll RegSvr32 c:\ETcomp2.ocx These components are used in my intranet site and works fine with my account (which has admin priveleges). But when I try to work on any other user account (no matter, admin or standard user), I always get this 'ActiveX Component cannot create object error'. With another admin account, I could see the component registry entries but still get this error. Couldn't find the ActiveX Installer Service useful, as these components are pre-installed and need not be prompted for installation from ...Show All

• SQL Server SUM returns incorrect value in SQL Server Mobile Query ... Bug??

  Hi all, I am a newcomer to Microsoft Database Technology and have appeared to come across an issue with the SUM function in SQL Server Mobile Edition. I am running Visual Studio 2005 and have created 2 tables: Orders and OrderLines which are set up in master detail fashion. The SQL Statement I create in the Query Builder is as follows: SELECT     Orders.OrderNo, Orders.OrderDate, Orders.Priority, Orders.Address, SUM(OrderLines.Quantity * OrderLines.QualityReference) AS Total FROM         Orders, OrderLines WHERE     Orders.OrderNo = OrderLines.OrderNo GROUP BY Orders.OrderNo, Orders.OrderDate, Orders.Priority, Orders.Address Now, the SUM ...Show All

• SQL Server Service Broker and routing

  Hi We are currently starting new project and evaluating possibility of using Service Broker in it but seems there could be some problems We have a central server with a central database and several hundred of “mobile” users. Information ( actually a subset which is specific to a particular user ) should be sent from/to central database and we wanted to use Service Broker for this. When you set up a route in Service Broker you need to define Network address which I believe should be an IP address or DNS name. The problem for us is that our “mobile” users do not have static IP addresses and I am not sure we can assign a unique dns to all of them. Mobile users can connect to internet in different places… and hence get ...Show All

• Visual Studio Team System Team Foundation Server Reporting account

  Hello, I have used the TFSSecurtiy Tool to change the TFS Reporting account and by error I used the same account than the TFS Services account. In the TF installation instructions mentioned that those accounts must be different. What can I do to change the account for the TF Server Reporting Thanks a lot, Montse You should be able to use the TfsAdminUtil.exe tool found on your Application Tier, though you'll also have to update the credentials that Reporting Services stores. A detailed walkthrough can be found here: http://msdn2.microsoft.com/en-us/library/ms252480.aspx Hope this helps! Cheers, Adam ...Show All

• .NET Development urgent help please

  hi all i would like to pass the more than 4 values from one page to the another using the datagrid hyperlink < asp : HyperLinkField DataNavigateUrlFields ="cutno" DataNavigateUrlFormatString ="pdmcutdocumentdetails.aspx cutno={0},code{1),description{2},doctype{3},filetype{4}" DataTextField ="cutno" SortExpression ="cutno" /> this is my code.. but am getting error in this.. i would like to pass the values cutno,code,description,doctype and file tyep to pdmcutdocumentdetails.aspx where in i ve to get these values in request.query string wats wrong with this code. how to solve this.. please help me am using asp.net 2.0 and vb.net code for this please hel ...Show All

• SQL Server Receiving a message with a specific contract

  If the service is defined with multiple contracts is there a way to receive a message with a specific contract I have a working implementation without Service Broker which handles message types and message priority (another one Service Broker does not handle directly). It does not make sence to switch to Service Broker which would also require to increse the complexity of the architecture. Alex ...Show All

• .NET Development Publishform just shows up and can't be closed

  Has anyone else had this problem a form called Publishform just suddenly shows up on the screen and in the taskbar and it can't be closed. It usually shows after using "copy web site". This last time I had used "copy web site" an hour ago and suddenly now it shows up. Any idea how to deal with this besides restarting vs Thanks Simmy The Visual Studio fourms here: http://forums.asp.net/138/ShowForum.aspx will be better able to answer this question. Thanks. ...Show All

• SQL Server better table management (partitions?)

  Hi, For my work I am now learning Sql server 2005 and I have been given a database that has been set up by someone else to work with. It is my job to get the database ready for use in reports. My problem is that the current database has one huge table with almost 8GB of data. The table contains data from 2004 to present (and growing) from 14 different countries. The reports we use are mostly per country, but we also want to compare the 14 countries to eachother for say, whole 2006.  At the moment the table is stored in one single file instead of using partitions. I believe partitions can give a good performance boost when running the queries. But how do I do this Currently the country codes are just plain text, can they be us ...Show All

• Windows Live Developer Forums Windows Live Contacts Gadget beta release!

  I'm pleased to announce that the Windows Live Contacts Gadget has been released to beta! The Contacts Gadget allows end users to access their Windows Live (Hotmail + Messenger) contacts in the context of third-party web sites, and use those contacts with the web site. It's easy to add the contacts gadget to your web sites - just reference the .js files on dev.live.com, copy one channel.htm file to your web server, and write a little code to construct the contact gadget and respond to its callback events. More details can be found here: http://dev.live.com/contactgadgets I'll be posting articles and code samples over the next few days on my blog . If you have any questions, feel free to ask! -Danny Good product, ...Show All

• Visual C# DataGrid + threading help - 'Controls created on one thread cannot be parented to a control on a different thread.'

  Im having trouble with threading, I have a DataGrid, and im downloading data from a server in a new thread. Once the data is downloaded I bind my arrayList to my DataGrid and create my DataGridTableStyle and add it to my DataGrid. When i run my app it crashes saying 'Controls created on one thread cannot be parented to a control on a different thread.' Here some code: Thread myThread=new Thread(new ThreadStart(readMessages)); myThread.Start(); private void readMessages() { // load messages from server ... // once messages loaded dataGridMessages.DataSource = arrayListDataGridMessages; DataGridTableStyle ts = new DataGridTableStyle(); // crashing here ... } Any ideas because im completly stuck. T ...Show All

• SQL Server Can not debug component?

  Who can help me I defined project properties: Start action--start external program : dtexec Action options--command line arguments: /f ***.dtsx (using component which i debug) Configuration: active(debug) I specified breakpoint after clicking build,dtexec can popup but then generate error: The following modle was built either with optimizations enabled or without debug information C:\winnt\assembly\GAC_MSIL\***\***.dll To debug this module,change it's project configuration to debug mode. I have no idea about this,and i can find my dll file in C:\winnt\assembly,but no GAC_MSIL folder Who can help me Thanks in advance Hi Andrew, i got the same error message as well. di ...Show All

• Visual Studio 2008 (Pre-release) MEX Security Requirements

  I have a WCF service that works fine with svcutil when I hit the mex url and it generates everything like I want it. However, if I change the application pool for the website that is hosting the service it breaks the mex. Everything else works, the service page and the wsdl page both load. But I can't use the mex with svcutil. What are the security requirements for setting the application pool identity to an account other than the Network Service account Thanks! -- Bryant as i know,mex binding should not depend on what account host process is running under can you please enable WCF trace(verbose mode) on service side,trace will provide more info about actual error message -Thank you M ...Show All

• .NET Development Creating Voice applications with VXML and ASP .NET

  I m about to develop a web application where in i need to create a VXML based on the request send by an IVR enabled server to my webserver (Which inturn receives a request from auser upon dialing a tel no) & send it back the VXML generated by my web application on the basis of the request received to the IVR Server so that it reads out the VXML & make the user listen accordingly. Now my problem is how to create a VXML file in .Net (secially in VB.net) & send it back to the IVR server & specifically how to identify the initial request send by the IVR Server to my application. We are using Voxeo IVR server as our voice recognition platform. I searched for these input on Voxeo Server community forum but couldn't get much ...Show All

• Windows Forms Problem Publishing to the Web

  After completing my application I used VB 2005 to "Publish" to the web and supplied a website address. After the publish I copied the published files to the correct directory on my website but whenever folks access the publish.htm page all they get on their screen is a dump of XML code. Any idea what I'm doing wrong. The install works just fine on my PC (with Visual Studio 2005 installed) but doesn't work on anyone else's computer wihout VS 2005 installed. Help! Thanks, Doug Thanks everyone for the replys. I did finally figure it out and it's an embarrasing mistake :) One of the first links you are requested to enter is the link to the "Publish" folder. I was entering the location a ...Show All