Answer Questions

• GuntherM1466 Publishing OLAP based Pivotables from Excel

  Hi I want to publish an OLAP based pivottables from Excel to a HTML file using Office web componets. I have a server with SQL Analysis Services 2005 cubes and I can browse the cube from my desktop in Excel 2003 Pivottables. When I publish the Pivottable with Pivottable interactivity I get an error in the browser: The query could not be processed - An error was encountered in the transport layer - The peer ...Show All

• kamald Deploy a Analysis Project Error: File already exists

  Dear experts, Whenever I want to deploy a analysis project, the Deployment always failed with the following error: "The following system error occurred:  File already exists. " This error always shows even I only create a new data source and then deploy it. What's going on.. ...Show All

• kabuki Problems adding MS access datasource in VB studios 2005 enterprise

  I am running Visual Studios 2005 enterprise edition and I am creating a mobile application to keep track of some receipts. The problem I'm currently having is that even though I can connect to the MS Access Database with Server Explorer that I'll be aquiring data from; Everytime I attempt to use the Data Configuration Wizard to add a new data source that namely the database I get this error message: The new connection uses a data provider tha ...Show All

• lamojo Execute a SSIS master package through an ASP.NET web app

  I am trying to execute a SSIS package via a web application built in c#.  I found a sample to read the output of a data flow task, but I'm stuck.  If I build the command line syntax for the package, create a DtsConnection object and set the connection string to the syntax, what else do I need to do   Thanks. Clay Thanks for all your help!  I am trying to set variables as we speak. ...Show All

• Cnash44 SQL 2005 Upgrade Paths

  What are the SQL 2005 Upgrade Paths   For example, is there a direct in-place upgrade for SQL 6.5   SQL 7.0   Can someone provide a link please   Thanks in advance. You can directly upgrade from SQL Server 7.0 SP4 and SQL 2000. Earlier versions must be upgraded to one of the above first (sorry no link) Oops, you'll also need SP3 or above for SQL 2000.      ...Show All

• Carlos Quintanilla Recovering from a lost log file

  I'm trying to make sure that we're following the "best practices" with SQL Server and I have some questions about log files. One general DBA rule is that data files must be on a different device than log files. This way, you can lose either disk and still recover all committed transactions. If you lose the data disk, you restore from backup and then rollforward all of the transactions that are in the log file. If you lose the log di ...Show All

• milesrush Synchronisation using web service for PDA application

  I am developing a application on PDA using c# compact framework. I would like to do synchornisation of sql mobile 2005 database with sql server 2005 database using web service. The reason for going to webservice is based on the client request. Will anybody help me on this, how to perform conflict management etc. Hi Maybe you find necessary information on the following pages: http://www.microsoft.com/tech ...Show All

• Harry Standley Need Article/Information - 2 databases 1 report

  Hi All, I need to find information on how to get two oracle databases data into one report. The two databases are not really a like, althought they do "talk" to each other and pass data to each other, and their tables are not the same. One is a manufacturing database, the other financial. If anyone can point me in the right direction, that would be great. I am working with the newer 2005 products. Thanks in advanced, Kerrie ...Show All

• Hitesh2 Date conversion

  I need help with date conversion from character data. In SQL 2000 we used a Date Time Conversion task I do not see how to do this in SQL 2005 SSIS. I tried a data conversion task to a database timestamp and this is what I got: [Data Conversion [383]] Error: Data conversion failed while converting column "date_time_stamp" (47) to column "Copy of date_time_stamp" (396). The conversion returned status value 2 ...Show All

• jfyfe Report Packs and SQL Server Express

  I am trying to use the IISLog report packs with SQL Server Express reporting services. The guidance in http://blogs.msdn.com/sqlexpress/ indicates that I need to change the target URL and the connection string so that the report packs work with SQL Express. I cannot see how to centrally change the connection string, so that it will affect all the Datasets in the report project. If I try and open a report page and click on the Data tab I get the ...Show All

• Sean Riddle Builder Report and oracle

  Hi, I want to create a model report project using a DataSource with Oracle, I am using de Wizard to create de Model Report but I get the follow error: ORA-000903 Invalid table name Command: Select count(*) From [TIG].[ATM05] Anyway to make Report Builder to omit the signs [] in the clause FROM Thanks for you help. Ana Sorry, Report Builder doesn't work with Oracle in the SQL 2005 release. Oracle sup ...Show All

• zdrae Oledb/Data Access Problems

  Hi all, I am going a bit crazy here. To give you my back ground I have done quite some work on SQL server 2000, VFP, VB6 and done quite a few web pages using frontpage. Now I am venturing into aspnet and have what seems to be some data access problems. I got a win2k professional web server and its running/has been running my frontpage web pages quite nicely either accessing them as //localhost/myweb or www.mydomain/myweb . Now I made so ...Show All

• Gyða SSIS and SQL Agent disaster (SQL Server 2005)

  I had a job scheduled for 11:59 PM daily, and decided to un-schedule the job and run it manually at 10:30 PM. I found that the job DID run at 11:59 PM also even though I had the 'enable' check box of the job's schedule unchecked. In the Job Activity Monitor the job also said that it WAS NOT scheduled. Has this or anything similar happened to anyone else Am I missing something Any input would be greatly appreciated. dinzana ...Show All

• Peter Holmdahl SQL Server Data Archiving

     I am wondering if there is a quick simple method of archiving partial data from a sql server db Is the easiest method via scripting or is there another more direct method Yes I am new to DBA methods. Any help greatly appreciated. Do you mean data from some tables when you say partial data or only some rows from a table There are many ways to do this. Look at BCP utility for starters. This allo ...Show All

• bashka66 SQL Server 2005 - June CTP

  Where can I download the developer edition of the June CTP - I could not find it in msdn or the main download page, where I could access the enterprize edition. Hi - If you still don't have it go to http://www.microsoft.com/technet/previewsqlserver2005/default.mspx Thanks Mirek  ...Show All