Answer Questions

• Paul Siermann 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

• Xingzeng SQL Mobile Server Tools

  I have installed VS2005beta with SqlExpress2005.  I am trying to install the mobile server tools but I get a message saying that the "SQL 2005 Connectivity Components are not installed".  I am 99.9% sure they are installed (I can go to add/remove and remove sql tools).  Any help would be greatly appreciated. If you are still experiencing this in the RTM version of Visual Studio, can you post a bu ...Show All

• Ivo Leitao RS 2005 run on SQL Server 2000 Database?

  Our product currently works with Cystal Reports but we decided to enhance it so it works with another reporting platform (MS Reporting Services).   We are in the beginning stages of developement and trying to decide which version of RS (2000 or 2005 ) to build the reports and integrate our web UI with.  Most of our clients are using SQL Server 2000 for their database platform and we don't anticpate them upgradi ...Show All

• drsmiley SSEUTIL -run question

  If I do the following: sseutil -create test.mdf sseutil -attach test.mdf sseutil -run testscript.sql it seems the first line in testscript.sql has to be use "<fullpath>\test.mdf" , or the script runs against some other database (which one, I'm not sure). It makes we wonder what the attach is doing. Anyway, I'm looking for a command file way to create and define a database that is not tied to a directory struct ...Show All

• ashishth Query Log File and Usage Based Optimization

  Hi I have successfully created a QueryLog.trc file but when I enter the Usage Based Optimization wizard it complains that I have not configured the server parameter QueryLog\ QueryLogConnectionString. Does the wizard support the use of a file rather than a table Im using the RTM version. Cheers Edward Thanks. The Usage Based Optimization wizard expects to find a SQL Server table. Here is whitepaper on how to setup ...Show All

• Roxanne163 closing pipelinebuffer

  Is there a way to signal to the PipelineBuffer during ProcessInput that no more rows are necessary Say I have a component's output connected to a custom destination component... in the destination component's properties, I can set the number of rows I want to consume.  (The first 50 rows for example.)  If I do it this way, the source component continues delivering rows - I can set my destination to ignore all rows after 50, but would ...Show All

• Rich12 using expression for image URL

  Hi, One of the fields that my sql query returns - IMAGE_URL - is a URL to an image file on the server, it has the form: file://myserver/myfolder/myimage.bmp I want to display this image in my report, but I want the image to automatically retrieve text of URL from my sql query. In other words I want to be able to specify image URL as an expression like this: =Fields!IMAGE_URL.Value However Web Image dialog doesn't see ...Show All

• Jason Haley Web App Failover problem

  Hi, I have successfully set-up a DB mirroring. When the pricipal goes down, the mirror picksup and the other way around too. So the mirroring part is working great. However, when I use my web applicaiton (dot net 2.0), it is not able to connect to Mirror server . I get the following error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that und ...Show All

• foobarX SELECT INTO OUTFILE?

  Hi, how do I redirect the output from a SELECT to a text-file, or Excel-file It is possible in MySQL, but what about Transact-SQL Thanks YOu have to use the OPENDATASOURCE method or a linked server to insert data in another destination than the local SQL Server. More information (including a sample can be found in the BOL) HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Vaclav Macak Import XML string into DB

  I'm not sure what an "edge" table is.   Can you post a sample of the XML, the OPENXML syntax you're currently using, and the output you're trying to achieve   -- Adam Machanic SQL Server MVP http://www.datamanipulation.net --     < GBez@discussions.microsoft..com > wrote in message news:c959c905-bfac-4471-b7a1-059439279ef9@discussions.microsoft.com ... Hi, I have ...Show All

• imba Urgent help is needed.

  Hi, I am trying to connect to a SQL server on a deferent machine using ASP.Net written in C#. The machine on which the SQL server reside dose not have the ASPNET user and the authentication is falling. Any ideas on how to connect using a different User. I changed the ASP.Net service on my machine to run as a deferent user MyUser, which is a domain user that have access to the server machine Note: We can not change the privilege ...Show All

• Kuda Why isn't there a MS Access Forum?????

  Ok, I've looked all over and I can't find a forum for MS Access. I can find a forum on every other component of MS Office, but not Access. Am I blind Anyways, seeing as SQL Server is the next closest thing to Access I guess I'm going to have to pick your collective minds and see if you can help me. Ok, I've found the Access forum. I'm going to try my question over there. Have a good one. ...Show All

• LEOJZAMBONI Unable to retrieve data from AdventureWoks

  Hi all, I have one question. It looks easy, but, I couldn't figure out the problem. I download and attach the AdventureWorksDB and AdventureWorksDW sample databases. I run the following query to test its functionality. use adventureworks go select * from production.location go and it gives me an error messeges which says: Msg 208, Level 16, State 1, Line 1 Invalid object name 'production.location'. Similar type of query is executed ...Show All

• Ravenet Formatting text within cell

  I have multiple words within a single tablecell and need to be able to make one of them bold, not the entired contents of the tablecell, just one word within it. I can't find a way to do it. Can anyone help me out Thanks. As far as I am aware you can't differentially format text in a cell. Andrew Watt MVP - InfoPath wrote in message news:5fe80da2-bdd1-4e54-987d-31f576f8913c@discussions.microsoft. ...Show All

• csmith54 Unable to read local eventlog (the parameter is incorrect)

  In trying to setup alerts and activating them, an error occurs in the sql agent log of Unable to read local eventlog (the parameter is incorrect) The full messages from the Windows NT Logs shows: Event Type: Error Event Source: SQLSERVERAGENT Event Category: Alert Engine Event ID: 318 Date:  03.11.2005 Time:  17:14:47 User:  N/A Computer: RESYSHADOW Description: Unable to read local even ...Show All