Answer Questions

• AngelaC Urgent help please!!!!! Error trying to uninstall RS sql 2k5

  Hello, One of our lovely NA's decided to remove IIS and the reinstall it while RS was installed before trying to uninstall RS. So RS broke. We then tried to uninstall RS to start over and get this error: The setup failed to read IIsMimeMap table. The error code is -2147024893 Anyone have a work around to get us to uninstall RS This way we can install IIS 6.0 from scratch and try to install RS afterwards. Thanks. ...Show All

• Runaway1956 SQL Server 2000 Standard Edition Log Shipping

  In trying to follow the directions to setup log shipping in SQL server 2000 I am having some problems. The option to check "Ship the transaction log to other SQL Server (log shipping)" is not located on the popup screen where I choose the database. It is missing entirely. Am I missing something somewhere and if so can someone point me in the right direction I am using SQL Server 2000 Standard Edition Version 8.00.760(SP3). ...Show All

• csi95 Pre execute Failure on Look up task

  Hi, I have an OLE DB Source. The output of OLEDB source is connected to a look up task. The output of the lookup task goes into OLE DB Destination. When executed.. I am getting this error: DTS.Pipeline: component "Lookup" (2834) failed the pre-execute phase and returned error code 0x8007000E. Any idea why pre-execute phase failure occurs TIN, Anand Hi, You are probably right. I have a data flow task bef ...Show All

• Gary Demi Why can I not read VARCHAR(MAX)?

  Hi there. Can Anyone help We have recently started to use SQL Server 2005 Express for a client. We have to accommodate some fields which exceed the 8000 character size for a VARCHAR, and all the advice says to use VARCHAR(MAX). If we do, we can place data there, but seem unable to read it back. We are interrogating via ODBC (SQL Native Client) using ASP (not .NET) on a windows 2003 server via IIS. We can find nothing at all on the web to h ...Show All

• MXQBear Can you please tell me where I'm going wrong in my asynchronous script component?

  Hi, Im new to this list and after many days of trying to figure this out-here we go Can you please tell me where I’m going wrong in my asynchronous script component I’m almost there but by using to variable iReadingCount to add the row is not quite correct. There has to be a better way !!! Thanks in advance Dave I have to process a data from a staging table this which has imported a data in a structure like ...Show All

• Eigil Installing SQL Server 2005 Express edition

  I'm trying to install the latest SQL Server Express downloaded from Microsoft. I've followed all instructions on the download page but get the message concerning Incompatible Components being found on my machine. To my knowledge I have never installed any previous components from any betas or other previous versions. Nor have I had a previous version of .Net Framework 2.0 on my machine. Just in case, I've checked Add/Remove Programs and run the ...Show All

• fireGeek Installing the SQL server 2005 beta tools problem

  Hi everyone,  I do not have any issues with the installation of the server itself, or reporting services etc... but im having trouble installing the tools like the management studio, etc... I get an error syaing tat I need to do this from the add/remove programs, but its not there. Its like it thinks that its installed but its not... Any ideas would be gratly appreciated Kramish Thank you very much Jeffr ...Show All

• Fallendown Error doing "Process Update" on some dimensions

  When processing some of the dimensions in my database using "Process Update" I get an internal error from the OLAP Engine (no specification)... Any known bugs on this, or am I just missing something Hy , i have this error too in Sql/olap 2005. This one is really bugging me Has anyone else had similar experiences Can you post here bit more information about your situation: The error description ...Show All

• mthendricks Create Flat File source programatically

  I created a SSIS package, added Script task. created data flow task programatically, trying to add a flat file source component programatically. stuck at this point. my goal is to add flat file source component to the data flow task and insert into a table in sql server using oledb destination component all programatically. any help is appreciated. thanks. Iam creating the connection, I w ...Show All

• Ian Ringrose Reference variables with identical names but different scopes

  Hi, I have a script task that can "see" 2 variables with identical names. The only difference is that they are scoped differently. As far as I know my script task will use the most locally scoped variable by default. Is there any way to make it use the other one -Jamie Hi it seems as tho I'm going to get much reply so I've submitted this at betaplace: 708844227 -Jamie Give people a chance, you only posted a few hours ago! Say ...Show All

• stephan mantler Importing unicode data from Oracle Database

  Hi everybody, i try to import data from an oracle database configured in unicode. When i run the package i have an error message Error at Data Flow Task [Source - ACCOUNT]: Column "ACCOUNT_CODE" cannot convert between unicode and non-unicode string data types. how can i resolve this regards. have you tried using the data conversion transformation component Importing unicode from Oracle 10g to SQL2005. S ...Show All

• Michael Mac Unable to run "Management Studio(ssmsee.exe)" for Sql Express edition

  Hi, I have downloaded Sql Express edition for Yukon. After that I installed the UI - Management Studio (SQLServer2005_SSMSEE). I checked and I was able to open and work using the Management studio. Afterwards I installed some "SQL Server 2005 Express Edition Documentation and Samples" from the following link ... http://www.microsoft.com/downloads/details.aspx FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&DisplayLang=en#filelist Now after i ...Show All

• Adam81 Adding Integration Services Node in Server Management Studio

  Hi, Am just getting started with SSIS. Based on an article I saw online, I would expect to find an "Integration Services" node in Server Management Studio, but I don't see this node. I'm trying to create and execute a simple package. Running...  Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)     Apr  9 2005 20:56:37     Copyright (c) 1988-2004 Microsoft Corporation     Beta Edition on ...Show All

• wdc1 Would someone try the following and post your result?

  I have a simple SSIS Package with a Source Excel Connection Manager and a Flat File Destination Connection Manager. The package executes successfully until I add a Package Configuration of type XML File.  When configuring the package configuration file, I chose the two connection managers (all properties) and left everything else (variables, properties, log providers and executables) unchecked.  After adding this package configur ...Show All

• DanHaligas 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