Answer Questions

• RMatthe URGENT!! localisation on Reporting Service 2005

  Hi, my company is doing localisation on reports generated by Reporting Service 2005. I understand from the blog http://blogs.msdn.com/bwelcker/archive/2005/07/03/435130.aspx that we can make use of Translation feature of SSAS for localisation of dynamic data retrieved from database. This is great. But, 1. Is there any other way for localising static text, other than using conditional expression when loading the text 2. Can we inte ...Show All

• m_3ryan Execute SSIS package from asp.Net

  Hi, I am a newbie to SSIS. I am trying to execute a simple package that I created from my ASP.Net application. I get the error 'DTSER_FAILURE'. Can anyone help Thanks HoustonRocket wrote: > the package is executed under ASP.NET service account, not your domain account. How do I address this Depends on what you mean by "address". This might be quite OK in some situations, but might be no ...Show All

• Ed Dore Subreports don't work in 2005 that did work in 2000

  I have embedded subreports which use Parameter Driven Stored Procedures as their record sources which work just fine in Reporting Services 2000/SQL Server 2000 but do not work in Reporting Services 2005/SQL Server 2005. Is there something that has been updated that would cause this to be the case I have exactly the same problem. But instead of not working, it works in the preview very well, but in the data ...Show All

• DenisG SQL2005 AS Named instance - SQL Browser issue?

  Hi all ( Note: This question was first posted on microsoft.sqlserver.connect last week, but I was advised that the MSDN forums was the correct place for SQL 2005 postings.) I have a development machine with SQL 2000 and AS 2000 sp4 on as the default instance SERVERNAME. I have installed the September CTP of SQL 2005 as a named instance SERVERNAME\YUKON. All appeared to go well, SQL server is fine and I've built tables etc. However when I ...Show All

• GaryGary AS2005 Cube Processed "Successfully", But Data Not Refreshed

  We process the cube automatically every night but the data isn't up-to-date despite a "successful" processing. However, if I go onto the server and process the cube directly there through the BI Dev Studio, the data will finally get updated. Similarly, if I try to process the cube from a client using Management Studio, it processes "successfully" as well, but the data is not updated. I have to do it on the server itself. I'v ...Show All

• Wellnow Only transform unique rows

  Hi, I have created a SSIS package which includes a Data Flow that will transform my data. The Data Flow Source for this Data Flow is a SQL Server table with approx. 60 mill. rows. Theses rows ought to be unique but isn't quite, so I would like to ensure that only one of each row makes it throug to my Data Flow Destination, another SQL Server table. What is the most efficient way to ensure this - is there some Data Flow Transformation that c ...Show All

• Shobha DTC error with concurrent data flows

  I have a package that has several data flows that run concurrently after some initial tasks and an initial data flow. I want transactions on each of the data flows and have set the transaction option to Required on the data flows (not on the package itself). I am also using checkpoint restart on the package. A couple things are happening. 1) the first data flow is successful and that releases the several that are waiting. Some of these compl ...Show All

• Rich Hopkins Subscription question

  I know there are possibilities to schedule reports on the hour, daily, weekly or monthly.   My questions now is, is it possible to schedule a report to run each hour but in a certain period of time each working day. For example, each hour on each working day from 8am till 7pm Or would I need to make different schedules for each time I want the report to be send   I can't find anything about this in the Books Online ...Show All

• Hexxagonal SQL Server 2005 Service Pack 1 is now available

  Microsoft announces the availability of SQL Server 2005 Service Pack 1 (SP1) with Database Mirroring, SQL Server Management Studio Express, additional options for ISVs, and normal feature fixes. SQL Server 2005 Service Pack 1 can be found here: http://www.microsoft.com/sql/sp1.mspx I have downloaded SP1, but I do not see SQL Server Management Studio. All I have is SQL Server Management Studio Express, I ahve Express version also in ...Show All

• k000der Transaction replication: Distribution agent owner

  Hello! I seem to have a permission issue when i setup a pull transaction replication on SQL Server 2005 which i was hoping someone could explain. The distribution agent gets created but when it tries to run it fails with: The job failed.  The owner (NATION\PK0159_a) of job EPPINF002\YUKON1-Publisher-Person-EPPINF004\YUKON1-Subscription-852824CC-803A-4C6B-B44B-748B6E25BFFC does not have server access However, when i change the ow ...Show All

• salmanpirzada sql replication

  As a newbie to sql I am currently investigating a deployment across 2 branches. My idea is to have 1 database, replicated between the 2 locations for performance reasons. In other words users in site A modify the local database while users in site b modify their local database and somehow changes in each site are replicated each way over the wan on a daily basis. Is this possible with SQL server standard 2005 If so, my only other question is I ...Show All

• bishop0859 Sql server 2000 instance database diagram from management studio

  I know it is clearly written in the bookonline that It is not possible to view or create Sql server 2000 instance database diagram from management studio. But could in any way I can just view the daigram(not edit) in management studio. Isn't it a good idea to give this support in the SP2 of sql server 2005 Please submit this to the feedback centre as a feature request. ...Show All

• programmerjoey Slowly Changing Dimension with 600,000 rows

  Hi, We have been using tasks generated from the SCD wizard. We have smaller dimensions (< 30,000 rows) that work well. Our Product Dimension package is giving us performance problems (taking 7 hours to do 600,000 rows when 80,000 records are updated; the rest new inserts). It is similar to the smaller dimensions. Several columns are type 1 and are doing update statements; several are type 2 doing updates and inserts. The package had a co ...Show All

• Jim Ward SQL Server Authentication + SSL

  Hi! I noticed that with SSL authentication (On SQL Server 2005), the SSL handshake is kind of "truncated" : * Certificate is not sent from Server to client; (Which may be OK according to TLS) * The client does not send Client-Key-Exchange message (Which is not conforming to TLS) This is clearly evident from tcpdump output. However with Windows authentication, the client -server handshake is "compatible" with ...Show All

• Guillaume JAY Where are my migrated packages?

  I have successfully migrated 50+ packages from 2000 to 2005. Where are they ! ! I looked through Management Studio and through Visual Studio ("SQL Server Business Intelligence Development Studio") and cannot find them. Note: When I open Visual Studio the splash screen confirms that Integration Services is installed.   Thanks   Did you use Migration Wizard to migrate your packages The migrated pack ...Show All