Answer Questions

• Gabriela D Connection to SQL Server 2005 Express?

  Hi all, I've been reading other posts for awhile now and I can't figure out what I'm doing wrong. I'm a Web Developer and not a DBA. I have SQL Server 2005 Express installed on my machine and it's working just fine. I also have the Management Studio Express CTP installed and working. I'm trying to connect to a database using a username and password (from ColdFusion Server which is working fine for external Oracle and Access databases, so t ...Show All

• pedron "...conversion between types DT_I1 and DT_I2 is not supported"

  I created a simple ragged file with 3 lines: 1 2 3 and coupled it to a Flat File Source. The Flat File Source suggested that the type was DT-I1. Next I created a “SQL Server Destination task and connected the output of the Flat File to the Sql Destination. In the Destination editor I created a table, whose one column was declared to be a sql smallint. Here’s the problem: the Sql Server Destination now disp ...Show All

• Darren Kennedy .dtsConfig ConfiguredValue contains environment variable?

  is this possible < Configuration ConfiguredType =" Property " Path =" \Package.Variables[User::varFolderName].Properties[Value] " ValueType =" String "> < ConfiguredValue > %enviroment variable% </ ConfiguredValue > </ Configuration > it would be really useful. it looks like the .dtsconfig file needs to be maintained on each install i ...Show All

• westerdaled Cannot connect to Express with Management Studio?

  Hi, I have installed an instance of SQL Server 2005 Developer Edition and another of SQL Server 2005 Express on my computer (Virtual PC, of course!). Management studio will not let me create a new database in the Express instance.  It says the express engine doesn't support full-text indexing.  I am aware of this, and do not wish to use this feature.  I just need Management Studio to manage my Express database.  Is there a ...Show All

• Jason L. What is the best way for users to view cubes?

  Hi, Our company is about to purchase SQL Server 2005 as an upgrade to running the reporting out of MS Access (so I am new to SQL Server). I have been trying out Analysis Services cubes and would like to know how others using SQL Server are allowing users to view cubes. I am using the Cube Browser from within an Analysis Services cube project which is excellent. This made me think that there must be an equivalent program that end users are able t ...Show All

• sbff Issue with Logging using SQL Server

  Hi All, I'm trying to implement the SQL Server logging in my package but Im receiving a very weird error message. Follow below: "Error at Consumer_Common_Transportation [Log provider "SSIS log provider for SQL Server"]: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "There is already an object named 'sy ...Show All

• cworkman29729 ORDER BY error

  Hello, in a complex stored procedure, i get an error when i want to apply an ORDER BY statement : Here is a part of this Stored Procedure : SELECT TaOperations . Id_Operation , TaOperations . HeureDebut , TaOperations . Signe , TaOperations . Facturer , TaOperations . IdUserVerrou , TaOperations . Id_Client , TaTypeOperation . Facturable , CONVERT ( CHAR ( 10 ), TaOperations . HeureDebut , 103 ) + ' - ' + TaTypeO ...Show All

• rythm SQL Task - Output Parameter fails using strings.

  Scenario: Using Execute SQL Task in SSIS. Connection Type: Ado.Net IsQueryStoredProcedure: True SqlStatement: [spAdoNetParamTest] I trying to return a output string from a stored procedure and place the value in a package level variable.  I am able to do this with other data types.  See sample SP below.  However, the task fails when trying to return a string with an error.  Does anyone know how to set the size property for a ...Show All

• clugsta Forcing Users to log out of SQL 2000

  I am a begginer to SQL. I am truly limited with SQL language. Every month we have to do a month end closing for our company. In order for us to do this we need to get everyone off the database to proceed. This process is horrible and generally takes at least 1/2hr to 45 min. to do so. i am looking for a command that i can use in query analyzer if possible to force the users out of the database. if that isnt an option can you recommend another ...Show All

• kc0rsc Model Information

  Is it possible to get hold of the fit parameters out of the prediction models in order to use them without going back to the database. E.g. With the linear fit model, y = ax + b, is it possible to get hold of a and b   This way I could use the fit equation and parameters directly within my C# code, rather than making many costly connections back to the database. Thanks of replying, but this still doesn't ...Show All

• Tomas_H Deploy apps using sql 2005 express

  i'm building apps using sql server express and I want to deploy to servers that have the 2.0 .net framework but have sql server 2000 database. Can this be done, and if so, how Observing God’s Holy Spirit , I see God sa yi ng that The Lord Jesus influences every natural occurrence of kindness, righteousness, and judgment (Jeremiah 9:23-24) . I believe God , so I thank The Lord Jesus for your grace in these matters. WHy do ...Show All

• Alex Belik Problems installing SQL 2000

  I installed VS 2005 which automatically installed SQL 2005. I wanted to also install SQL 2000. I tried to install SQL 2000 (Client tools) after 2005 was installed and there were errors. I then uninstalled SQL 2005 and tried to install SQL 2000 (client tools). This is on my local machine not a server. I am getting the following error: "A connection could not be established to XXXX\SQLEXPRESS. Reason: SQL Server does not exist or access ...Show All

• DiaNagele Remot_Backup

  How can i take a backup of remote sql server and that .bak file will save on my local system is there any T-sql code for it Connect and login to the remote SQL Server, and run: backup database myDb to disk = 'pathToMyLocalDisk\myDb.BAK' -- edit This assumes that the remote SQL Server is able to reach your local disk over the network, and also have permissions to write there, however. /Kenneth ...Show All

• ahmad.nazmi cannot convert between unicode and non-unicode

  I keep getting the error message below when attempting to import a text file (flat file) to an SQL Server Destination using SSIS. This database has recently been migrated from SQL Server 2000 (where I used a DTS Package that worked fine). I plan on doing further manipulation to the file after importing but have so far tried to keep one step at a time. I have tried using a smaller files and different tables but still get a similar response. I bel ...Show All

• RyanB88 Reporting Services Performance

  Hi, I'm just wondering if anyone else has had any problems with reporting services when generating reports. I have a rather large report (approx 5000 rows) and to be fair there are alot of links to other tables. However it takes 5-10 minutes to generate this report. If I manually pull the data from the database, perform the aggregations and all the table joins, it takes under 10 seconds to complete and I seriously doubt that rendering the table ...Show All