Answer Questions

• Kokyu Workgroup Edition SSIS Features?

  Hello, If I have an instance of SQL Server 2005 Workgroup, am I able to run simple ETL packages against it By simple I mean: 1. Extract data from a comma separated flat file. 2. Load the flat file data to an Access (2002/2003) database. 3. Load the flat file data to a SQL 2005 table. 4. Execution of .dtsx package. 5. Ways to execute a package (i.e. can schedule a package to be run with the SQL Server Agent) 6. Notification ...Show All

• ofa Management Studio and Beta versions

  Hi, Does the SQL Server Management Studio Express (CTP) November 2005 work with Sql Server 2005 Express which was included in the Visual Studio Team Suite 2005 Beta 2 Thanks, shiversticks SQL Server Management Studio Express only works with the RTM versions of SQL Server 2005, SQL Server Express, SQL Server 2000, and SQL Server 2000 Desktop Engine. You can download the RTM SQL Server Express here: ...Show All

• Colmeister FTP No Files Error

  When running FTP Client, and there are no files found on the FTP site and error is thrown.  Is there any way to catch this condition and reset the error so does not bubble up to the parent package I want to catch the event that there are not files on the FTP server to get so that I can set a variable appropriately, but then I want to branch on the condition and return to the parent package and not have the parent package see the error that ...Show All

• DanMelson I can't install SQL Server 2005 Developer Edition

  I copied the error I received.  SQL Server Setup cannot install files to the compressed or encrypted folder: C:\Program Files\Microsoft SQL Server\. To continue, make sure that your installation directories are not compressed or encrypted, or specify a different directory, and then run SQL Server Setup again. C:\Program Files\Microsoft SQL Server\ is not an compressed or encrypted folder.  I don't know what it is talking about.  ...Show All

• Ali D Enable User Instances in SQL Server

  I'm just starting out and trying to connect to my first database using the following string: Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RFPdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True I get the following error during debug: " Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances ." I've done this on every database ...Show All

• Cliff hewett sql server 2005 diagram support

  For some reason, when I try to access a database diagram on our new 2005 SQL Server, I get the following error msg: "Database diagram support objects cannot be installed because this database does not have a valid owner" It then goes on to instruct me to either use Properties > Files or ALTER AUTHORIZATION to change the database owner. Well, I've done that - and it clearly shows that there is an owner of the database, but e ...Show All

• TreeSapp Error creating Report Model based upon Oracle Database

  In MS Visual Studio, when creating a new Report Model Project, after defining a datasource to an Oracle database (and successfully testing it), and a simple datasource view (1 table), when I click "Run" in Report Model Wizard, I receive the following error: "ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }" It does not appear that one can create Report Models from an Oracle database (since the SQ ...Show All

• Steven Wilmot SqlServer2005 can support merge replication with SqlCe2.0??

  Hi guys, Correct me if I'm wrong. That's wat I was doing.. Try to perform a merge replication between the 2. But the following errors are wat I've got during the syncronization: Error Code: 80004005 Message : Run Minor Err.: 28557 Source : Microsoft SQL Server 2000 Windows CE Edition Err. Par. : ssce:database;password=mypassword;data source=Program Files\helloWorld\database.sdf; Error Code: 80040E14 Message : The OLE DB Execute method failed. ...Show All

• Terry Smith IE Scripts and Printing Error

  hi i am using the RSS 2000 version with the service pack 2. it all works fine in my development machine and other test machines in the office but when i take it out into the real world and try to print IE says it cant run some scripts. i have checked the ie security settings and tried enabling all scripts and still the report viewer insists it cant run some scripts and gives me an error. does any one know where i can change settings to enable my ...Show All

• M.A.T Cannot get rid of SQL server 2005 Developer Edition Installation

  I cannot uninstall the SQL Server 2005 Developer Edition.  I have run the uninstall from the control panel for ALL of the SQL Server 2005 components.  They are no longer listed in the installed programs list.  I have done the uninstall with both the Control panel and the command line. When I try to install SQL server Express (Downloaded from the web last night)  It will not install.  The error message is: TITLE: Microsof ...Show All

• 7racer Can't find SSIS ???

  I have VS2005 and have been using SQL 2000. I installed SQL 2005 Developer but I can't find SSIS anywhere. It is hard to start even the first tutorial if I can't find the program. Was it supposed to be installed with 2005 Developer Help! Thanks in advance. Chuck Did you select to install Integration Services and the development environment. If you did, the best way to Start to is to open the Business Intelligence Development Studio ...Show All

• mikecmr No data in cube while browsing (URGENT!)

  Hi, Okay, I am in deeply stuck. I am creating Dimensions, Cubes thru AMO. I update the datasourceview according with tables and relations. The creation of dimensions are perfect. I can process the dimension, I can browse the dimension data. Next I create a cube as given in the microsoft link: http://msdn2.microsoft.com/en-us/library/ms345091(SQL.90).aspx except for some slight modifications to the microsoft code, the general f ...Show All

• quemi RDP & Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The conne

  As a starter i tried to modify and translate the Personal Website Starters kit from the VS2005Team SDK. When i'm working on the machine were it's installed , under debugging, all works great. But when i try to develop from my laptop, via RDP on the develop machine, i've got this message and can not debug (connect to the SQLxpres Server) Does anybody now a solution Failed to generate a user instance of SQL Server due to a failure in ...Show All

• chadinsky Query:Source from multiple tables to a Fact table

  Greetings, Iam new to SQLl2005. Iam using DTS to transfer data from my source to the warehouse. I have a couple of tables in my source whein I have to join these to tables fields and insert the same in teh warehouse fact table. I have used a Join query in my Oledb source component, What other component needs to be used to insert the data into the fact table. I also need to extract same data with aggregation and insert the same into an another F ...Show All

• ruhollahakbari Problem with security when running a subscription report

  I am using Reporting Services on a SQL 2005 server and am having problems getting my security setup correctly. Here is my situation. I have successfully created data sources that connect to a SQL DB on both the same server as RS and a remote server. I have been able to get the reports to run successfully thru report manager on the local server and also a workstation. I have also been able to get the report to run successfully thru a su ...Show All