Answer Questions

• Alex Vergaray Wizards missing in Enterprise Manager?

  Hello, I just installed MS SQL Server 2000 Developer Edition on my computer running Win 2k Pro, and all seems to have gone well. But, when I run the Enterprise Manager and select Wizards... under the Tools menu of the Console Root\Microsoft SQL Servers window the only Wizard I see is the Register Server Wizard. If I understand everything I've read, there should be more wizards available. Can anyone tell me what I'm missing here Thanks in a ...Show All

• JeffM Raising errors in Validate() method

  Hi, I am building a custom component. In the Validate() method I am checking for various things. Here's a section of my code: if (ComponentMetaData.InputCollection[0].InputColumnCollection.Count != 1) { return DTSValidationStatus .VS_ISBROKEN; throw new Exception ( "You need to select one and only one column" ); } The problem I'm finding is that my Exception never gets thrown so I never see the e ...Show All

• Jean St-Arneault Data Truncation error.

  i trying to import a text file to a table which has the following fields transid int transitem tinyint value money starttime datetime info nvarchar(128) On my text file, i put column 0 as numeric col 1 as four-byte unsigned integer [DT_UI4] col 2 as currency [DT_CY] col 3 as database timestamp [DT_DBTIMESTAMP] col 4 as Unicode string [DT_WSTR] then it give me Warning 1 Valida ...Show All

• Mehfuz Hossain How to programmatically render reports?

  We are working on a new C# application. This application will not have a user interface; it will run "behind-the-scenes". This application needs to programmatically generate reports--it needs to be able to render reports to a predefined output format (HTML, Excel, etc.) and it needs to be able to send the rendered report to a predefined location (fileshare, e-mail, printer, etc.). How can we programmatically render reports with a sp ...Show All

• Martinro73 How to insert a lookup table row aftre lookup fails

  I want to do a a look-up, then if that lookup does not find a record I want to insert a new record into the lookup table, so that effectively the lookup now succeeds. How can I do that I can't figure that one out. TIA FYI it is often more performant not to redirect the error rows but to just do a filter on the rows that don't have the lookup value. This is all down to the redirect creating a new row, and the associated costs of assigning m ...Show All

• CoolVanilla Getting Field List to display in Reporting Services 2005

  In VS2005 Report Designer how do you get the field list to display. In VS2003, The field list for the data sets shows on the left side of the screen under the toolbox without having to do anything. In 2005 I don't know how to make it appear at all. Any help, thanks in advance. Ctrl-Alt+D or from the last item on the View menu, select Datasets. ------------------------------ This posting is provided " ...Show All

• DarrenMcD Performance, handling 1.2 million rows takes 7-8 hours?

  Hi! I'm working on a project restructuring some data using SQLIS. The problem is one package that is handling about 1.2 million rows takes about 7-8 hours to complete. To my question, is there any of the dataflow components that are know to be slow that you should avoid regarding performance issues The following list is a brief specification over the component that are contained in the package: --------------------------------------- ...Show All

• Priscilla87945 Login failed for user...

  Hi! I have msde (that installed with an application) on the old computer. Now I am setting up a new computer and I want to use SQL Express with this application so that I could easier manage databases. I have installed SQL Express 2005, attached databases from the old computer, created an ODBC system data source and created user "AD" to use with this application. Now when I try to log on with this program I get the following e ...Show All

• Caged Isolation Level at flow not connection level

  Why is the isolation level specified at flow level and not connection level It means you can't mix isolation levels in a data flow. ...Show All

• Ruhsert Convert Access SQL to ANSII compliant SQL

  I don't want to sit here and re-engineer Access SQL to SQL Server ANSII all day.  Is there a cool that will convert a sql statement if you past it in to ANSII   Or what other techniques can make my life easier in the process if you have any up your sleeve Also, is there anything in .NET or even SQL Server 2005 to help convert SQL statemetns from Access to SQL Server AFAIK, there are no tools to do this. If you however write y ...Show All

• leandro Oliveira Management Studio and Enterprise Manager on Same Machine?

  Greetings! Do any of you know whether or not it's possible to install Enterprise Manager onto a box with SQL Server 2005 installed I've come across a couple of problems when trying to admin some SQL 2000 servers, so I need EM somewhere. Also, it's incompatable with SQL Server 7.0, of course, and I've got two of them to admin as well. Thanks! Unfortunately I installed the sql2000 client only tools and the ...Show All

• aaronkool29 Can SQL Server 2005 Evaluation be used to upgrade a system?

  I have multiple development SQL Servers running Enterprise edition that I want to upgrade for application testing before upgrading our production system. All of the servers meet the hardware and software requirements for SQL Server 2005 Enterprise edition. However, when I try to install to use the SQL Server 2005 Evaluation Edition to upgrade the servers in place, I get the blocked upgrade message: Name: Microsoft SQL Server 2000 Reason: ...Show All

• twyk168 Errors in the high-level relational engine

  Hi members, could some help me and explain why i am getting this kind of error. My cube executes successfully with errors. Thanx Ronald Errors in the high-level relational engine. The data source view does not contain a definition for the 'dbo_Prescription' table or view. The Source property may not have been set. See my reply to your previous post. Edward. -- This posting is provided "AS IS" with no warranti ...Show All

• Morten Dahl Cube Template

  So my problem is the following, i have created a cube without using a data source (from the wizard of cube creation). And i have generated the relationnal schema thanks to the following wizard. But i don't succeed to bind the data from my database to this cube. I found no documentation for this problem, not in the msdn books onlines eigther. Thanks ...Show All

• Ebey Meadows Value dimension

  Hi, I have a dimension 'Customer' with 15 customers. When I look at the value of a customer it shows : [Customer].[Name].&[1] (this is the value for Kelly Woods). Is it possible to show it as [Customer].[Name].[Kelly Woods] thx You need to put it in your connection string. Here's an example of what it might look like: "Data Source=MyServerName; Provider=MSOLAP; Initial Catalog=MyDatabase; MDX Uni ...Show All