Answer Questions

• bromba cube processing error - perhaps someone can explain

  I have one fact table that is also a dimension table + one other dimension table. When I deployed the cube I was getting an key attribute missing error. I went back and did a "Process Full" on the fact diminsion and then the cube would deploy without the error. Should a fact dimension always be set to process full thanks What could have happen here is: You've processed your dimensio ...Show All

• Chris4510 sql DB on Server1 and SSIS server on Server 2 problem

  I want to deploy my packages to the MSDB on Server1 and I want to use the SSIS server on Server2 to execute those packages. so: Server1 = SQL Server, Server Agent Server2 = SSIS server, SSRS server, SSAS server Question1: I'm using this setup because then the CPU on Server2 is used for processing the package, right So ... I want to execute a Job on Server Agent on Server1 to run packages stored also on Server1 but the SSIS ser ...Show All

• MissBook Using a hyperlink in sql server reporting services

  I have added a table on to the body of my sql server report.In one of the columns of the table I have dragged a field which is the output of a stored procedure. Now i want to make this field a drillthrough hyperlink(by using the jump to report option) based on a condition. I am not able to do that. Any idea how to achieve this Thanks for your answer. I wrote an expression with a condition on action->jump to report. But it still sh ...Show All

• ManOPT Cannot create an ODBC connection to SQl 2000.

  Hi all, I have SQL 2000 enterprise edition(no service pack) installed on a Windows Server 2003 machine. I can remote access into the server and run SQL but I cannot create an ODBC connection to this from my desktop. From some research it looks like installing service packs might correct this but here is the error: --connection failed --sqlstate '01000' --sql server error 10061 --connection failed --sqlstate 08001 --sql serve ...Show All

• Testking SSIS SCD Type I, Dim table Compound Key selection for Business Key

  Hai, I have been working in DW for a while, but using SSIS as an ETL tool is new for me. I worked extensively on Informatica. Coming to my question, right now I am trying to do SCD type 1. But my dimension table has a compound key. i.e more than 1 column makes a key for the table. But SCD wizard allows to select only 1 attribute as a business key. Does any one have any suggestions on how to implement SCD if the target table has compound ke ...Show All

• John Colasante How to assign Unique PKs and FKs on split of txt rows into DB tables

  SSIS 2005 Ok, I have a task in SSIS that does the following and works: 1) Brings in a txt file 2) Using a conditional component, checks for a value in the row. 3) Based on the value, splits the row into one of 3 tables (Header, Maintenance, or Payment) Here is a print screen of what I have so far which splits Header rows into it's own table, Maintenance rows into its own table, and Payment Rows into its own table: http://www.we ...Show All

• devstuff raw file destination and environment variables

  when using a raw file destination it would be nice to be able to use an environment variable for the filename property. like %my_extract%\data.txt instead of c:\my_extract\data.txt Raw file adapters have an AccessMode property, which allows you to enter a filename or a variable name. Variables can obviously use expressions. the gui will not let me click the ok button ...Show All

• jhughes96 INSERTs given me the BLUES

  cstring = cstring + "VALUES('%" + txtWatchID.Text + "%','%" + txtcenter + "%'" & _ cstring = "INSERT INTO tblNEW (watch_id, service_center_num, repair_envelope, store_number" cstring = cstring + "date_purchase, transaction_num, cust_fname, cust_lname, product_code" cstring = cstring + "value_watch, failure_date, service_date, failure_code, repair_code" cstring = cstr ...Show All

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

• Polaris7* ErrorCode and ErrorColumn in Excel Destination

  I am exporting records with errors to Excel using the Excel Destination tool. The ErrorColumn is a numeric. How do I find out which column it is If you want to do this manually (i.e. not programmatically), you can open the Advanced UI for the Excel Dest, and go to the "Input and Output Properties" tab.  There, under "Excel Destination Input", you can look through the colums. As you click on each one, look ...Show All

• laughing gnome The AdventureWorks Database Diagram Sucks!

  Shouldn't there be some design discussions on the AdventureWorks database diagram Does everybody agree with the design Are there any major or minor flaws in the design Was the database normalized correctly - if not where and why Do you agree with the choice of surrogate and natural keys Why do you think it was done this way and not that way Are there any data modeling vendors (other than Visio) that have created this schema usi ...Show All

• LeeH Duplicate Events

  The nature of the event provider for my SQLNS application is to produce exact duplicate rows into the event table.  Obviously, I am not interested in receiving duplicate notifications.  What are some strategies for having SQLNS produce one notification for several exact rows being sent to the events table. I have an event chronicle that retrieves distinct rows from the event table and puts them into the chronicle.  My thoughts w ...Show All

• Jay Wise SQL Dependency

  Hi! Is there any way to use the sqldependency feature from ADO.NET with SQL Server Express editation I need this feature but I develop a shareware application and I can't buy Professional or higher SQL server for every downloaded copy. Thanx. Here is a MS article that includes info about the SQL Dependancy for 2005. http://msdn2.microsoft.com/en-us/library/ms229862.aspx It is very nice, but I want wind ...Show All

• cybrenergy i created a login in SQL SERVER 2005 EXPRESS, but cant login...

  create login dave with password='abc', default_database=tempdb when i use this account to login my sql2005, i got Msg 18452, Level 14, State 1, Server DAVID-398113F7C\SQLEXPRESS, Line 1 Login failed for user 'dave'. The user is not associated with a trusted SQL Serv er connection. why Try posting on the SQL Server SMO/DMO forum with the text of the error and a description of the steps you took before you received it. The ...Show All

• Bharath Kumar J Is it possible to change the operator of an expression at run time?

  I have a report I have created in local mode, in a Winform ReportViewer using VB.net. Is it possible to change the operator of an expression at run time That is, I have a filter on a list that looks like this: Expression: =Fields!InvNum.Value Operator: = Value: =Parameters!InvNum.Value It is possible in code to change the operator from = to >= at the time I run the report If so, what is the syntax What I would like to do (do ...Show All