Answer Questions

• GoldenBrown2 DSO in SQL2005

  Anybody can share the way to administer AS2005 using DSO Hi, thank you for the details. I use the DSO Object for AS2000. Where can i find the DLL for DSO 8.5 I use the Interop.DSO.dll for DSO and AS 2000 and have to set e new reference in the project for DSO 8.5. With the old DSO it is not possible to acces the AS 2005 :-( Hop somebody can help me Hello, ...Show All

• Hal T Export Truncating - Simple Report

  System: SQL Server 2000, with RS. Problem: Occasionally an Excel export for a report will be truncated. When we set up several schedules for the same report to be run serveral times with different parameters and emailed as Excel, a few of the reports are truncated (e.g. instead of 88 rows, there will only be 1 row in the report) - and no error is logged. I was able to reproduce using VS 2003 within Preview - the report viewed fine, but the expor ...Show All

• Borislav Job Execution Error - Please Help

  I have started having a problem with my SQL Server 2005 SSIS system and it has become a nightly event. What is happening is that sometime in the evening before 7:30 the server gets into a state in which any SSIS job that attempts to run, fails. The error message that SSIS reports is: An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Could not bulk load because SSIS fil ...Show All

• SuperNova298 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

• Helixpoint Need Advise on SQL Express with Advanced Services

  Hi Guys, Need some advice on the free SQL Express with Advanced Services provided. I plan to develop a small departmental multi-user applications with 5 to 6 simultaneous users using the free SQL Express with Advanced Services with VB.net and stored procedures on a local area network. Is it a good choice to use this free SQL Express with Advanced Services or is it more advisable to purchase a standard version Appreciate if someone c ...Show All

• evslin Input column collection in script component?

  Does there exist an input column collection in script component What I mean is that if I have 10 input columns with names: a,b,c,d...i,j Then, within the script component, can I access any column collection such that column[0] has value for column named 'a', column[1] has value for column named 'b' and so on.. Using Row.a , Row.b, Row.c and so on does not give the flexibility to get/set values in a loop. thanks, Nitesh You don't do it in ...Show All

• preissen User Definded Aggrigates

  Hi, I'm currently working with SQL Server 2005 Management Studio. I'm unable to view the user defined Aggrigates, can some one suggest me about the same In other words, where i can find the details of user defined aggrigate functions Regards, That's odd.  Do you have CLR enabled on your instance   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID ...Show All

• DianaChia IIS Internet Info Services

  Hi, I'm trying to install SQL Server 2005 Enterprise edition. It is telling me that I don't have IIS installed and that it may cause some problems. I can't find where to install from add/remove components nor can I find it in any of my network connections. Does anyone know where to install this from Thanks in advance. Newbie.......Eric Yeah that's a bummer. Well I'm just learni ...Show All

• Munni Custom Front-End Using Multi-Value Parameters on Reports

  Hello, We have developed our own ASP.NET 2.0 (C#) front-end for Reporting Services (SQL Server 2005). The front-end is kind of "generic" in the sense that it looks at all the parameters for any report selected by the end-user and creates a display for the end-user to configure the parameter values. This all works fine, except for one report that has a multi-value parameter. On the report viewer through Report Manager, this multi-val ...Show All

• Lorenzo Castelli Code page conversion shortcut?

  Is there a simple way to avoid having to use a data conversion task to convert Unicode data (from DB2) to ANSI format (for insert to Oracle) I'm hoping that there is a way to set the code page property on the OLEDB driver so that it implicitly converts to the format I want instead of having to explicitly force the conversion in the package. Thoughts suggestions -Clayton In the intervening month, the best method I've come up wit ...Show All

• Martin.Cruz Inside a project you lose the control??

  I've got a project with 12 packages. One of them runnning and at the same time when I try to alter another one or even add a new task I see that all the tasks on toolbox are disabled. Why I would like to hear a good reason for this behaviour, afaik I don't get the point... Often the packages in one project call into each other, so if one of them is currently executing - there is a good chance others will be running as well. Although ...Show All

• Bryan Janes How to write a Function that can return a value from a dynamic database?

  I need to get a value from a dynamic data base, and I thought that the best way to do this was by using a scalar function. I'm not too experianced in writting Functions... so I thought I'd post here and see if it is possible, and if so, how Basically, I will be using 3 parameter: varchar @DataSource (the datasource string in the form of "server=SRV;uid=USER;pwd=PWD;database=DB;") int @RecordId (the primary key id column ...Show All

• madriceg The connection manager 'OLEDB' is not properly installed on this computer

  Please help someone from MSFT! I've just finished installing the Sep CTP on my laptop.  I previously had the April CTP and June CTP.  I followed the instructions for removing a previous installation of SQL 2005. Now, when I try to create an SSIS package, I get a message that says: TITLE: Microsoft Visual Studio ------------------------------ The new connection manager could not be created. ------------------------------ ADDITIONAL IN ...Show All

• Scott Currie SQL Server 2000 DTS Tools Web Download

  Is the Web Download to install SQL Server 2000 DTS tools available yet If so where Thanks Darren If I answer my own question, at least I'll get one right. SQL 2000 DTS tools are now available as part of the - Download details: Feature Pack for SQL Server 2005 Nov 2005 ( http://www.microsoft.com/downloads/details.aspx familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en ) The direct link to the MSI- http://www.microsoft.com/do ...Show All

• moviejunkie temp table cannot be found

  SQL Question -   declare @sql varchar(1000) set @sql=select count(*) INTO #tmpReport from TableA exec (@sql) select * from #tmpReport go   How come exec(@sql) indicates that 1 row inserted, but I get "Invalid object name #tmpReport" from the last select statement.   Any help is appreciated! -Lawrence the local #tmpReport is created out of scope (i.e. anything executed i ...Show All