Answer Questions

• dncjp Incremental cube processing

  I'm trying to use the "Process Incremental" option when processing a cube in SSAS 2005. There are about 100million records in the fact table, but I'm only interested in the most recent 1.5 mil that were added last night. It's acting like a full process because it's reading all the rows in the fact table and not the ones most recently added. Do I need to specify (in the config options) a query/table that only points to the new rows ...Show All

• Tony Spaulding More installation woes

  We have releases a shrink wrapped winforms application that uses SQL Express as its backend. The product has a fairly large take up, and consequently it is being installed on a large numbre of different machines and configurations. We seem to be having quite a common problem with the installation of SQL Express, we launch the installation from our own installation package with the following command line SQLEXPR.EXE /qb ADDLOCAL=ALL SQLAU ...Show All

• KPLNG XML Service Broker messages

  Hi, I have written a C# console application that adds a message to a SB queue and a C# stored procedure that reads the message from the queue. I have had so many problems that I'm beginning to doubt the usefulness of this, but that is probably just my frustration speaking. I am stuck on putting an XML message into the queue and reading the XML in the stored procedure. The console app has a simple object called Message. This class has ...Show All

• Norbert Eder Copy data from one table to another

  On the OLE DB Source, I have as following: select field1 , field2 , field3 from table_source On the OLE DB Destination, I used fast load option with table lock checked, and check constraints to copy data to table_destination. Both table_source and table_destination have the same table definitions. After the dtsx package ran, the number of rows copy over to the destination is not same. I got different results from different runs. This ...Show All

• Martin Born Report Designer "XML Regions"?

  Is it possible to create "Regions" (as in the .NET VB/C# editors) in the Report Designer XML Editor If so how -Brian ...Show All

• Twigg Can you use Rank to get rows 51 to 60 of a query?

  I have not installed SQL Server 2005 yet (hopefully this weekend), so I have not been able to experiment yet. One of the things I had hoped would be added to T-SQL is a way to get a range of rows out the middle of a query to populate a table, e.g. when you are showing the user page 6 of many.  I had been hoping for a variation of SELECT TOP something like: SELECT ROWS 51 TO 60 * FROM MyTable WHERE State = 'CA' ORDER BY CustomerNum ...Show All

• No.1 Of Mew SQL Server DTS - viewing transformations

  We have a DTS package that has a very large number of transformations in it.  The DTS designer displays these as a huge number of little lines that are almost impossible to work with (looks almost like a barcode at this point).  Is there another way to view these transformations, or is there a 3rd party tool that anyone knows about that we could use to make this a bit more user-friendly   ...Show All

• Jesse - MSFT Easiest way to start and read a trace from within a SSIS package

  I'm trying to gather information from within a SSIS package for benchmarking, reconciliation, and reporting purposes in regards to cube processing, which I'm initiating using the AS processing task. What is the easiest way to capture this information The only way I've been able to come up with is to use a profiler trace. If this is really the only way, what is the easiest way to execute and read the trace from within SSIS Also, if a script ta ...Show All

• Scott Mason SQLPrepare and SQLExecute returns Permission Denied in SQL 2005

  I am trying to determine what has changed in SQL Server 2005. We have a application that has used this SQLPrepare and SQLExecute pairs for several years now and all of the sudden on 2005 it fails with a -1 error. Code Sample: odErr = (ODErr)SQLPrepare (hstmt, (PTR)gODCDA->sqlStr, SQL_NTS); if(!odErr){ odErr = (ODErr) SQLExecute(hstmt); } The Statement was "Select * from dbo.tbl1234 where 1=0" This is a standard way we use to get a ...Show All

• greenhorn_programmer Connecting to SQL Server 2005 Express Edition from VS 2003?

  Hi, How do I connect to Sql Server 2005 express from Visual Basic. Net 2003 Kumar Hi, normally this should be no problem, do you this programmatically or do you want to connect with the server explorer. Connecting with the server explorer should be no problem, which error are you getting HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Hi, just fro ...Show All

• Ken Robertson Run Time Error While Execute Sql Server 2005 Integration Services package from C#

  Hi I am trying to Execute an SSIS Package from C# Dot Net. Below the code i am using. try { Application app = new Application(); Package package = app.LoadPackage("DTSPackage/WinServeMonitoring.dtsx", null); DTSExecResult result = package.Execute(); label1.Text = "Package Execution " + result.ToString(); } catch (Exception exp) { label1.Text = exp ...Show All

• arif_setiawan Bulk Insert won't compile if file doesn't exist, no Try Catch either

  I first noticed that the try/catch did not seem to work when the text file did not exist and I tried to execute this block of code from a stored proc. Then, when I tried to compile the proc using a file that did not exist at the time of compilation, I can't even get it to compile. If I compile, then remove the file, the try/catch does not work. TRUNCATE TABLE LoadDaily; BEGIN TRY  BULK INSERT LoadDaily  FROM 'c:\temp\daily.txt'   ...Show All

• Monty Shaw RSExecutionLog_Update.dtsx error!!

  Hi, When I execute the RSExecutionLog_Update.dtsx, I get an error saying "The task "Set Time period" cannot run on this edition of Integration Services. It requires higher level edition". I am using the Proffesional Edition of SQL2005 and the Integration Services Version is 9.00.1399.00. I have configured the target database RSExecutionLog correctly. Wat could be the problem TIA Is th ...Show All

• Tech Guy WCF Transport Channel for Service Broker

  I saw a posting or read a blog somewhere that mentioned custom WCF transport channels where created for interacting with ServiceBroker. Has anyone read or heard something similar If so, where can I get them Thanks. Phil We do not have any official plans to release a WCF channel as a service pack or add-on. Could you explain why you are looking for a WCF channel You could answer Gerald's question to Phil ...Show All

• Rickahooy Counting no. of records

  Hi I need the ability to calculate the no. of records based on the no. of times a value in the sql report is given. For example based on a table shown below: Ref No. First Name Surname 18 test test 18 test test 18 test test 19 test test 19 test test I need to calulate the records returned on the ref no. I have managed to set page breaks based on a new ref no. with grouping and therefore the count will be disp ...Show All