Answer Questions

• SneshaA XML Bulk Load

  I am trying to load data from two different elements to the same database table but keep getting errors. It appears that the sql:relationship is not defined properly but I am unable to find anything explaining how to define the relationship. Would someone please help The xml data is: <billers> <biller Key="8279" > <billerInfo> <billerId>0062599175</billerId> <billerName>AAA Hawaii Insuran ...Show All

• Jim at bernco Existing Oracle Program Prevents SQL Server Express Being Installed in Windows XP Pro that is in NT 4 Network

  Hi all, Our Microsoft NT 4 Network has Oracle program for all the Windows XP Pro PC terminals to use. We did not have the SQL Server Express Beta version installed before. Recently our Computer Administrator tried to install the SQL Server Express Edition that is downloaded from Microsoft Website to my Windows XP Pro PC terminal without luck, because the Oracle program is already in our LAN Network and prevents the installation of the SQL ...Show All

• Thom Little ReportViewer control for WinForms - can I copy text?

  I am using the ReportViewer control for Windows Forms, and I would like to be able let my users copy text from the report. Is there any way to configure this At the moment, the text is not selectable. Thanks, Erick Unfortuntately, the text is not selectable in the winforms reportviewer control. This is something we hope to enable in the future. I understand, thanks. I've b ...Show All

• John P. Greiner Tx replication works in 2000 but not in 2005?

  Hello, I've got a simple transactional replication set up. I have a separate publisher, distributor, and subscriber with 76 articles (tables only) being pushed from the distributor. I have this exact setup with the same tables and data working in the SQL 2000 environment. I am testing replication on our SQL 2005 test servers before moving to production, however when the distributor attempts to push out the initial snapshot I keep getting ...Show All

• Shane Harris SqlServer 2005: How to test Cube Actions

  I'm working with Sql Server 2005 Tcp, I've created a test Cube, and a Cube Action. Someone can tell me How I can test or Show It Thanks Alex ...Show All

• suppechasper Windows Authentication

  When I create reports using a data source that uses Windows Integrated Security and that connects to a database that does not reside on the Reporting Services server I'm getting the following error: An error has occurred during report processing. Cannot create a connection to data source '<data source name>'.  For more information about this error navigate to the report server on the local server machine, or enable remote errors If ...Show All

• Guiller DTS - Import Text Files

  Hi, I am really new to DTS so please excuse if you find my query to simple. I have a text file which has lots of records which I am trying to import into a SQL table using a DTS package. The format of the text file is like this Field1        ,Field2        ,Field3             ,Field4 Field1 &nbs ...Show All

• sun.Xiang Supporting Current RDL Spec

  Does Reporting Service have the concept of supporting 2003 level RDL and 2005 level RDL separately (like Excel or Word does with their various formats ) or since most changes are merely additions does the latest version of Reporting Services just consume old RDL 2003 spec files and output only the new version of the Spec RS 2005 works with the 2005/01 RDL spec. Report Designer 2005 will load old RDL files and ...Show All

• MichaelJosten Column detach task ?

  Sometimes you have some columns in the dataflow that you at some point in the flow doesn't need in the further flow. So maybe a tast or an option for disabling columns that are no longer in use Why do you think this would be of benefit If its for disabling those columns at design-time then I think its a good idea. I think "disabling|" is the wrong word however, "hiding" would be more appropr ...Show All

• Babant merge agent error

  Hi We are using HTTPS merge replication. One of my subscribers is getting this error: Error messages: The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload). (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402)   This is a bit surprising - it has been w ...Show All

• Sydonn Unable to use SSMSE to connect to SQL Express server on secondary IP address

  I am having trouble to use SSMSE to remotely connect SQL Express server using IPs other than the base IP of the machine. Machine settings: (1) Has multiple IP configured. Those IP are accessible remotely (2) Firewall is not on. SQL Express server configuration: (1) TCP/IP and named pipe are on Browser service state: (1) running (2) listening at 0.0.0.0:1434 (UDP) SSMSE connection results: (1) with <ba ...Show All

• Brian Z Getting more information of a Job / Aborting a render-request

  Hi, I'm developing a webapplication where users can view reports very fast (no login required, reports are directly shown as pdf->no annoying prompt). Therefore I gave ASPNET some permissions and all currently processed reports(jobs) have the owner ASPNET. In some cases a report could take a long time, so I want to give users the possibility to cancel their report (to free server resources). How do I do this I can cancel the corres ...Show All

• xanthus Creating a package with data flow task programmatically

  I have created a simple package with 1 data flow task: Source: data reader (to sql mobile) Destination: oledb (to sql server) And the aim is to do a "Select * from table_name" from source and move everything to destination database. I have followed the steps in documentation, but the package fails! An exception is thrown with message: "Exception from HRESULT: 0xC0202072" Since its the basic functionality of SSIS that I am implementing, it ...Show All

• robmaag1 Converting @myString to @myInt

  Here's a fun one.  BOL says that using CONVERT or CAST to change a string into a number won't work. The following "works" and I'm assuming it is because the compiler can verify that the string value is in fact a number, even with the Unicode N: declare @col2      int select   @col2 = convert ( int , N '12345' ) ====================================== Here's what I need to work, or I need a creat ...Show All

• troy2 Visual Studio 2005 Reports are not deploying at SQL server 2000

  I have converted reports designed in Visual Studio 2003 to Visual Studio 2005. The reports are running fine when I preview them from Visual Studio 2005. I am getting error message “The attempt to connect to the report server failed.   Check your connection information and that the report server is a compatible version.” As soon as I try to deploy these reports, I am deploying these reports at SQL server 2000 report server. Please let me kn ...Show All