Answer Questions

• dhweizel AND OR question

    Can I set  up constraints to be AND OR.  I have 4 tasks (A,B,C & D)   I want D to fire when the follwing criteria occur:   (A or B) and C. I haven't managed to do this, as when I set up the OR constraint, all of the green lines turn to OR's as well.   Many thanks in advance for any help         Hi Jamie Yes, that works perfectly. Many thanks. By th ...Show All

• tc1109 question about Dimensions...

  I'm reading Microsoft 'SQL Server 2000 Analysis Services' by Reed Jacobson and have come across a passage which I don't understand. Being fairly new to this I was hoping someone could help: "Consider this extreme example: with 128 members in a single dimension, a report has 128 possible values, but with those same 128 total members split up into 64 dimensions - with two members in each dimension - a report has 18, 446, 744, 073, 709, 551, 616 po ...Show All

• tracy97214 ODBC Destination in SSIS

  Hi! I have a problem that stops me from using Integration Services as THE ETL tool. My goal is to load a data warehouse type of a database. The database is MaxDB (former SAP DB), but this is not the point. Let's take ANY ODBC compliant DB and assume all I have is ODBC driver - no OLE DB driver. I figured out how to read from ODBC source (using Data Reader and ADO.NET provider for ODBC). Now my question is how do I output/write my data into ODBC ...Show All

• Jerry2000 merge agent error

  Hi We are using HTTPS merge replication. One of my subscribers is getting this error: Error messages: The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload). (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402)   This is a bit surprising - it has been w ...Show All

• Brian F. Question: how to filter records from the output of a Multicast?

  Question: I am using a multicast transformation task. Input to the multicast task is an OleDb Source task that retrieves data from one table X. There are 'n' multicast outputs (say 4). For each output, I want to filter the records and push the resulting records to the corresponding Ole DB Destination (different for each output). By filtering, I mean, specifying something like a WHERE clause that can operate on the Multicast output columns. What ...Show All

• Daniel R. Tarsky SCD and populating dimensions and facts

  Hello, This is my first task in attempting to populate a fact and dimension table from SSIS. I have a Fact table Sales and dimension tables Customer and Location. The data I am getting to fill this structure is in one file. where each record contains the sales information as well the customer information and location details on the same row. I am using the SSIS to fill this structure by using the slowly changing dimension for the Customer ...Show All

• Uhh SQLExpress database using SQL2000 driver?

  I recently converted my MSDE databases to SQLExpress and it seems to work fine. I noticed in my ODBC Administrator that the database names appear in the System DNS. The driver says "SQL Server" which in the drivers tab appears to be the driver for SQL2000. Am I running an instance of SQLExpress using SQL2000 drivers Will this cause a problem Should I try to set up new data sources (same database names), using SQL2005 drivers ...Show All

• 71EFBB98-D1FE-4eff-BAC5-F94AC74 Displaying AS hierarchy in ASP.Net

  Hi, I'm currently working on a project where we're building a custom UI , pretty soon, we're going to have to build in the ability to browse an AS hierarchy. We would like to use a traditional treeview control or similar. I know this is comig down the line so I'm trying to pre-empt any problems we might have by trying to sort them ahead of time before I go on vacation (which is tomorrow - yeay :) ). Does anyone know of any technical res ...Show All

• goliver22 Problem attaching a database

      Hello, I have made a database in SQL Server 2005 Developer edition. I tried to attach it to a SQL Server 2005 Express Edition but I coundn't. I can attach and dettach it to the developer edition but I cannot do it to the express edition. When I am running the store procedure: exec sys.sp_attach_single_file_db @dbname = 'LinGS',   @physname = 'c:\LinGS.mdf'   I receive the following error: File activation failure ...Show All

• Rooster242 page number & records number

  1. how to show page number & total page number in report body 2. how to show total records number for #1: I can't think of another way to output the page numbers, so you might have to just use the header and footer to handle it. for #2: Create a text box and enter the value: =CountRows("DataSetName") This will output the number of rows returned by the dataset. ...Show All

• bodhi147 move file task using variable

  Hi, Using the 'for each' container, I am setting a user variable (type = string) which will hold the source file name and path of files to process and then move to an archive directory. In the move file task (which is in the for each loop container) I have set the destination to a file connection, and the source to : Issourcepathvariable=True;  sou rcevariable= user::sourcefilename BUT when I run the package, I get the ...Show All

• dstuparu How to backup asymmetric key in SQL 2005

  How to backup asymmetric key in SQL 2005 created in the following way so it can be copied to another server Also can you copy it to the other server after backing it up. CREATE ASYMMETRIC KEY ccnumber WITH ALGORITHM = RSA_512 ENCRYPTION BY PASSWORD = 'password'; I figured out a way to grant permissions to the web user to decrypt data encrypted using asymmetric key. I can do that using alter auth ...Show All

• mr Umesh kumar Full text indexing question

  All, I am using the standard edition of SQL Server 2005. I have a table I want to put a full text index on but it is greyed out. What are the reasons why it would be greyed out Thx jonp It is 90. Does that just mean that I am using SQL Server 2005 I assume 80 would be SQL Server 2000, right Yes, it does or specificlly, it means that the database 'customer' ...Show All

• Will Wilson Post Installation error with RS2000 on Win2000 Server

  Hello, I have installed RS2000 with no errors, but when i browse to localhost/Reports i get an RS error page that reads: "An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help The profile for the user is a temporary profile. I have checked the LogFiles (C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles) and the error mes ...Show All

• Arold37 List SSRS2005 items on treeview

  Hi all, I'm creating a Custom web interface for SQL Server reporting services 2005. What I want to do is populate a "Navigation Treeview" component in asp.net 2. How would I get all the catalog items and items from the web API and populate my treeview Thanks Hi there Brad, Thanks alot! I'm still having some trouble though... I'm using this code to get the list: Try Dim P ...Show All