Answer Questions

• Manhattan Create File Option In File Connection Manager

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• sosleepy Complex Transformations (SSIS components vs TSQL)

  Greetings SSIS friends, I have been attempting to implement one of our numerous ETL processes in SSIS but hit a brick wall when I tried replacing a complex stored procedure with a series of Merge Join components. In the end, I had to settle with using a SQL task which merely calls the stored procedure and this proved to be the better option as the other version where I used SSIS components only took forever to run. How do people c ...Show All

• Paul Minnaar Sub Report page footer not visbile in the main report

  Hi , I have a sub report which has a page footer.This page footer has page number & a text box which dispalys something based upon the parameter send from the main report. Iam calling this sub report 5 times from the main report by passing a parameter , say @D ( @D =1 ,@D =2 , @D =3 ,@D =4 & @D =5). Here my problem is that the page footers doesn't get printed when the main report is executed. My 2nd requirement is that , the ...Show All

• Aaron Stern - MSFT Return COMPUTE from stored proc

  I'm trying to figure out how to get my stored proc below to just return the result for COMPUTE only : ALTER PROCEDURE [dbo].[procname] AS BEGIN Select (cast(FGoal as numeric(30,2)) / FSched) * 100 AS gt from DR WHERE e='06' group by CustomerName,          CustomerNumber,          FGoal,          FSched order by CustomerNumber COMPUTE SUM((cast(FGoal as numeric(30,2)) / FS ...Show All

• Henry N Create user error!

  I have just managed to have JDBC working, but I am getting an error that the user does not exist. I have read in the MSDN help that I need to set the sqlExpress to accept SQL server authentication and not windows authentication. So when I am trying to create a new User using Microsoft SQL server management studio express I get the following error. TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Crea ...Show All

• Scott C. Reynolds How to find matching profiles?

  Users have to answer 17 simple yes/no questions and the answers are stored in an column for each question as tinyint 0/1 values. At least that's what seems reasonable to me at the moment. The table is under my control so I could change it if needed. Now from several tenthousend or maybe hundreds of thousends of entries I need to find those with the closest match. Of course, I need all of the entries that have the exact same answers and this is n ...Show All

• SmokingMan is there any way to get isqlw running under sql 2005 install

  I regulary would have 4 or 5 separate sessions of isqlw running.. and it is much less overhead than running multiple sql server managment sessions and also much better in the way the windows tile... the new interface sucks in my opinion .. thanks in advance ok to answer my own question get the following files off of an old 2000 install and put them somewhere in your path I put them in the winnt directory 1/30/2006 ...Show All

• LSwanson tables setup

  How would I set up a sql server database based on the following problem I will be creating a poll based on 9 dimensions that compare two companies. honda yamaha performance features reliability conformance durability serviceability aesthetics safety other perceptives The values stored would be 1 or 0 so the values can be totalled. The user will be using a web page and will select a radio button per di ...Show All

• James_lh Read-Only Cell

  Hi, When I create a new xml column using SQL server 2005 the column by default is set to "read-only cell". I've looked around at the properties and don't see anything to change this behavior. Anyone know what I need to do so that I can write to this cell useing the SQL browser. I'm able to update the cell programatically, BTW. Any help greatly appriciated. - Pardner test, plz ignore wrote in ...Show All

• Arti.Desai Installation support for XP SP2

  When I try to install SQL Server 2005 on my computer (Windows XP with SP2) I get a warning from the installer telling me that my operating system is not supported, this is the warning I get. - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software R ...Show All

• --JC-- Error: Attribute key cannot be found

  Helo, I have the following problem I have one fact-table in my cube And I have one dimension table When I process the cube I get the following error: "Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306." I understand the error, and I know why I get the error, but how can I solve the error In the fact-table there is a record with key 306, but this key is not fo ...Show All

• DanLeg How to fix postion of report itme?

  I'm mirgating a invoice report from Crystal Reports to RS, I've some questions on controlling position of report items. I put a list at the body of report. At the top of the list, it displays general information of invoice, like invoice no., customer name, address, page no....., I want those information print on the top of every page. In the middle of list, I use a table to display invoice details, it may have many lines and longer than one page ...Show All

• Dayanidhi Invalid length parameter passed to the SUBSTRING function

  Hi all, I am having a weird issue after we upgraded our DB server to SQL 2005. I have a SP used to extract exchange rate, and a job calls this SP daily. This job worked fine on SQL 2000, and works very well in Management studio if I call this SP seperately, but failed in sql job in 2005. The error statement pointed to: select left(@row, charindex(',', @row)-1), REVERSE(left(@reversedrow, charindex(',', @reversedrow)-1)) The error ...Show All

• Mr S Migrate DTS 2000 package doesn't work

  Hi everyone, I'm stuck with this and I haven't idea how to solve it. I'm trying to migrate a dts 2000 package from BIDS and I obtain this message: This wizard will close because it encountered the following error: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index (mscorlib) I'm going to Migrate DTS 2000 Package select my current sql2k production server (it has almost ...Show All

• Brad Rhodes - MSFT Converting text data to ntext data

  Hi all, My organization have a web-based application and needs it to support multilingual so we will be adapting our app to use unicode. However, one of our problems is to convert existing data from text to ntext. I couldn't find anything that document this. What is the best way to do that I would like to be able to migrate the data from an existing text column to another ntext column in the table. I brief you about my system, I used List manag ...Show All