Dangerous MSI Microsoft SQL Server 2000 DTS Designer Components
Nov 17, 2006
Microsoft SQL Server 2000 DTS Designer Components has cause a total destruction of my Enterprise Manager.
In my workstation I've got Sql Server 2000 client and Sql Server 2005 client. Everything goes fine up to here.
But when I've installed that MSI I have not been able to open my Enterprise Manager.
From MMC appears: Error initializing component CLSID: {xxx.xxx}
My goal was be able to open 2000 stuff from Sql Management Studio. By the moment, I'm forget of that.
Does anyone have ever faced this issue?
QA is working.
Thanks in advance for any suggestion
View 6 Replies
ADVERTISEMENT
Feb 27, 2006
Is there a X64 version of Microsoft SQL Server 2000 DTS Designer Components from Feature pack for SQL Server 2005?
I have installed an X86 version on the AMD64 machine. But when I open a sql 2000 dts package, there is always a warning window.
The Message is as follows:
SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.LegacyActionBase.CreateLegacyDesigner()
at Microsoft.SqlServer.Dts.ObjectExplorerUI.OpenLegacyPackageAction.Act(INodeInformation nodeInfo)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.DtsServerMenuItem.Invoke(INodeInformation parent, String mode, String assembly, String type)
There are two same assemblys called 'Microsoft.SqlServer.DtsObjectExplorerUI' in the GAC, and one is GAC cache type, the other is zap cache type.
View 4 Replies
View Related
Oct 30, 2006
Hi,
I learned this from one of SSIS book-Migrating from Data Transformation Services to Integration Services in SQL.
For the design time components, Microsoft has created a special distribution called the Microsoft SQL Server 2005 DTS Designer Components. The Designer Components distribution replaces the components that get uninstalled when you upgrade your last instance of SQL Server 2000. If you want to upgrade all your SQL Server 2000 instances, this is the best and only option for recovering the DTS designer.
Is anybody heard of this 2005 DTS Designer component?
Where to download? How it works? Any experience to will be appreciated.
Thanks,
Charley
View 3 Replies
View Related
Dec 5, 2006
I kept getting DTS packages edit message before upgrading my DB from Upgrade advisor, even though I don't have any DTS package. Would someone help on how to Retain or restore the DTS Designer by obtaining and installing the special Web download of SQL Server 2000 DTS Designer Components?
View 1 Replies
View Related
Jan 30, 2007
Hello,
After Having installed the SQL Server 2000 DTS Designer Components necessary
to edit legacy DTS packages on 2005 server, I keep getting the following message when trying to open SQL Server 200 Enterprise Manager:
"The procedure entry point
?ProcessExecute@@YAXPAUHWND_@@PBG1@Z could not be located in teh dynamic link library SEMSFC.dll."
Is there a way to fix so that I can open Enterprise manager?
Thanks!
View 9 Replies
View Related
Mar 24, 2006
After installing the DTS 2000 designer components from the feature packI get the following error message when trying to open a package:
----------
SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)
---------
The thing is that I have installed them!! so what's going on here, is there a registry key I need to remove or something?, I've uninstalled and re-installed them, rebooted the server numerous times but still no joy, SQL Server just tells me that they're not installed, as you can imagine this is a real pain as I cannot do anything with my legacy packages on the 2005 server.
I cannot just migrate the packages from my 2000 server as they are in daily use on a production server. Is there an option to migrate/copy packages but leave the source packages untouched?
Help!
View 6 Replies
View Related
Aug 23, 2007
Hi, I have installed SQL Server 2000 and Reporting Services 2005 and Visual Studio 2003 all works OK but I need to create a report with the Microsoft SQL Server Report Designer 2005 and it doesn't appear in my VS, someone could help me with this?
Marcos.
View 8 Replies
View Related
Jul 4, 2007
Hello,
I have DFTs with around 50 components and future ETLs will have 100+ components in DFTs.
I was wondering that is there anyway to group components like we have #region in C#.
Thanks,
Kapil
View 4 Replies
View Related
Aug 20, 2007
Hi,
I installed SQL 2005 Enterprise Edition and SQL DTS Designer Components. However I cannot find the icon of the SQL Designer Components.
Thanks.
Lian.
View 1 Replies
View Related
Jun 25, 2006
Hi All,
I am not sure if this is a correct forum to discuss on the document posted @ http://www.microsoft.com/downloads/details.aspx?familyid=1c2a7dd2-3ec3-4641-9407-a5a337bea7d3&displaylang=en on SQL Server Integration Services (SSIS) Hands on Training - Creating Custom Components.
I am assuming Microsoft Developers are constantly monitoring this forum.
In the document - SSIS Creating a Custom Transformation Component .doc on Page 2 -
Exercise 1 - Writing the no-op data flow transformation component -
Task 1 - Create a new C# Class Library Project
The textual description talks about creating a new Visual C# Class Library project in VS 2005 but the screenshot accompanying it shows the creation of new "Integration Service Project" in VS 2005.
Please change the screenshot appropriately to avoid confusions.
Thanks,
Loonysan
View 1 Replies
View Related
Sep 26, 2006
Hello all,
After reinstalling several times the MSSQL 2005 express, and the SP1 when I'm trying to create a project with the BIDS I've got an error:
Could not load file or assembly
Microsoft.ReportingServices.Designer
Version=9.0.242.0
..
or one of its dependencies. System cannot find the file.
But it exists!!!What can I do?
Many thx!
View 22 Replies
View Related
May 29, 2008
Hi,
Pls let me know if SQL Server 2005 Management Studio (client tools only) is compatible with Windows Server 2000 or not?
Thanks in advance.
Regards,
Bhuvana
View 1 Replies
View Related
Mar 28, 2007
I am not sure where to ask this question. So I figured here may be ok
I have several DTS 2000 packages and I have SQL 2005 installed on my local machine. However the rest of the company is still using SQL 2000 (for now). So I do not want to convert them to ssis yet. One of the things we just did to the packages is make all flat files use \localhost and any servers point to (local). Now in ssis this works fine but using the DTS 2000 package designer it does not like either of these at all. The reason we wanted to do this is so when we switch out servers there is no changes to our DTS packages.
View 2 Replies
View Related
Nov 27, 2007
Hi!
Using VS2005, trying to make simple reports :
TITLE: Microsoft Report Designer
------------------------------
A connection could not be made to the report server http://<myNonLocalServer>/ReportServer.
------------------------------
ADDITIONAL INFORMATION:
The request failed with HTTP status 400: Bad Request. (Microsoft.ReportingServices.Designer)
Have no problems to access http://<myNonLocalServer>/ReportServer and http://<myNonLocalServer>/Reports
This is an new installation of reportserver.
Configure Report Server:
All green, but
SharePoint Integration: blue
Encryption Keys : blue
Email Settings : yellow
Execution Account: yellow
Platform: Windows Server 2003 Standard x64 Edition
SQL Server: SS2005
@@version says: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Visual Studio on my local pc:
Microsoft Visual Studio 2005
Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework
Version 2.0.50727
Installed Edition: Professional
Microsoft Visual Basic 2005 77718-204-0000007-41260
Microsoft Visual Basic 2005
Microsoft Visual C# 2005 77718-204-0000007-41260
Microsoft Visual C# 2005
Microsoft Visual C++ 2005 77718-204-0000007-41260
Microsoft Visual C++ 2005
Microsoft Visual J# 2005 77718-204-0000007-41260
Microsoft Visual J# 2005
Microsoft Visual Web Developer 2005 77718-204-0000007-41260
Microsoft Visual Web Developer 2005
Crystal Reports AAC60-G0CSA4B-V7000AY
Crystal Reports for Visual Studio 2005
SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 9.00.2047.00
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 9.00.2047.00
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 9.00.2047.00
...
Report-solution-property:
TargetServerURL: http://<myNonLocalServer>/ReportServer
How to deploy??
View 1 Replies
View Related
Feb 17, 2004
My objective is to use Enterprise Manager to move (copy) my SQL db from the server to my windows desktop computer.
I downloaded MSDE and am having trouble installing it, no doubt because I do not understand the documentaion (ReadMeMSDE2000A.htm).
When I try to run setup, I get that message that says:
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same."
Considering my purpose, do I need a "strong" SA password? If not, how do I get around it? If yes, how do I set it up?
I am a Mac user so I have poor windows skills, please make it as painless as possible for me, thanks!
Ron
View 3 Replies
View Related
Feb 16, 2006
venu writes "Hi,
Am very new to MS SQL adminstration
Can anybody help me out how to work on Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A just for the practice.
The activity which am going to workout on MSDE is below.
How to install SQL(on XP)
How the layout will be(like if i insall MSDE what are all Application will be and how they depends on each other)
How to create/delete tables if so, how can we do it either by GUI or CUI
just i need a clarifications reg same
Thank you,
venu"
View 1 Replies
View Related
Oct 31, 2007
Hello,
I am running Windows Server 2003 R2 Enterprise Edition SP 2
I have created an integration package in VS 2005 which extracts data from Access 2000 and imports it into a table on SQL server 2005 running on this server.
The package runs ok in Visual Studio 2005, but when i schedule it as a step in 2005 SQL Agent to execute as a SQL Server Integration package using SQL Agent Service Account it comes with the following error -
I did a bit of research which suggests this is due to SQL 64 bit and Windows 64b bit, however I am running 32 bit !! also the sql server agent is a domain admin user...can you gurus please help ?
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 10:07:42 AM
Error: 2007-10-31 10:09:13.85
Code: 0xC0202009
Source: Copy all Data to Reporting Prod Connection manager "Access Allocations.mdb"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
End Error
Error: 2007-10-31 10:09:13.85
Code: 0xC020801C
Source: 5_Copy vw_Allocations 5_Access Allocations [1]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Access Allocations.mdb" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
End Error
Error: 2007-10-31 10:09:13.85
Code: 0xC0047017
Source: 5_Copy vw_Allocations DTS.Pipeline
Description: component "5_Access Allocations" (1) failed validation and returned error code 0xC020801C.
End Error
Error: 2007-10-31 10:09:13.85
Code: 0xC004700C
Source: 5_Copy vw_Allocations DTS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2007-10-31 10:09:13.85
Code: 0xC0024107
Source: 5_Copy vw_Allocations
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 10:07:42 AM
Finished: 10:09:13 AM
Elapsed: 91.422 second
View 29 Replies
View Related
Apr 26, 2006
asif writes "sir i have microsoft server 2000
and i have to use taht in my pc only
i have instaled taht in my pc but when i run sql query analyser then its asking for database and many more please solve my problem.
i am using windows xp service pack2
so please help me
"
View 2 Replies
View Related
Jul 20, 2005
i wanted to restore user DB from one sql server to another sql server ,one database is having so many table and have user called digihe is created so many SP and some tables., when i restore the db itrestored without any problem.,after restoring application is not workinghow to ensure that restored DB is having same security as the originalfor that user .when i tried to run the script of that db over that restored DBit was showing user digi does not exist. but i have creted user digiwhere can i get the useful information about this/sreeni--srinPosted via http://dbforums.com
View 1 Replies
View Related
Jan 31, 2006
Greeetings!
I am newbie in SQL, asking help from you people.
We are using Microsoft SQL Server 2000 Service Pack 2 running on Windows 2000. We are planning to update service pack from to 2 to SP4...Is it okay? What are the requirements? Will there be side effects in our systems?
Hope to hear from you soon.
Regards,
Len
View 1 Replies
View Related
May 7, 2004
I'm unable to gain connectivity to two stand- alone PC's having WIN XP PROFESSIONAL, v. 2002, through Microsoft SQL SERVER 2000. :eek:
Both the PC's are stand-alone and have both have WIN XP PROF. I installed Microsoft SQL SERVER 2000 in which only the Client Components were successfully installed.
I have the Administrator Rights on both the PC's.
The Problem on both the PC's that I'm facing is as follows:-
On starting SQL Server Enterprise Manager, the PC was not detected as a Server under the SQL Server Group, and thus I selected the option 'New SQL Server Registration', then I gave my full computer name (as appears in the properties of 'my computer'), selected Windows Authentication and then selected OK to start or connect.
It did not connect and then I got the following error message:
-------------------------------------------
A connection could not be established to 'COMPUTER NAME'.
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect())
Please verify SQL Server is running and check your SQL Server registration property (by right click on the COMPUTER NAME_node) and try again.
OK
-------------------------------------------
On starting the SQL Query Analyzer, firstly the message connecting to 'COMPUTER NAME' was seen and then it also gave the following error message:
-------------------------------------------
Unable to connect to server 'COMPUTER NAME':
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][Shared Memory] SQL Server does not exist or access denied.
OK
-------------------------------------------
where the 'COMPUTER NAME' stands for the name of the particular system that can be seen in System Properties-> Computer Name-> Full computer name.
I had installed the MDAC Components from the Windows Update website.
I checked the registration properties and have tried many times but everytime the same error messages were received in both the systems and all the efforts bore no fruits.
Both the systems are:
Intel P4
WINXP PROF. v2002
128MB DDR RAM
40 GB HDD
Please help soon as I am studying SQL Server!
THANKS. ;)
View 14 Replies
View Related
Jul 31, 2006
Hi
I never use Microsoft SQL Server .. somebody told me to start with 2000 version .. but I know that there is 2005
I want to know if it is ok to start with 2000 version and at the same time i can follow others who use 2005?
Thanks
View 4 Replies
View Related
Sep 19, 2006
Hello,
I would like to see if Microsoft has issued any announcement on SQL Server 2000 end of support. If anyone is aware of this or seen new posts/articles, please let me know.
Thank you!
View 3 Replies
View Related
Dec 17, 2005
Hi all,
I'm new to this forum, though not new to sql server am new to DB2.
We are running Microsoft SQL Server 2000 but we have recently acquired similar business in another country which runs IBM DB2 database system. We are interested in incorporating the data from DB2 in our system. The tables are slightly different in DB2.
Q. what is the best way to integrate the two systems? Should we take the route of a federated system or replication of data?
We are interested in knowing what is happening in the other business (DB2) but we what the two systems to operate in parallel for about a year, before we come up with the best solution.
The company is after a short term and long term solution.
Can any one please help or point me to the right place?
Regards,
Chloe.
View 2 Replies
View Related
Jan 29, 2004
Trying to install Microsoft SQL Server 2000 Desktop Engine on my laptop. I downloaded the software and opened it to a folder on the C drive. Then from the command prompt I entered this:
C:msderela>setup sapwd = hillary instancename=mjh targetdir=c:mike
The program starts to install and seems to get near to the end of instal and then the progress bar starts going backwards and nothing gets installed....any ideas of what I'm doing wrong....I really don't know anything about this at all.
Thanks
View 14 Replies
View Related
Feb 13, 2006
I'm working towards MCAD and as elective I want to do the SQL Server course. The exam is on SQL Server 2000. I was just wondering whether the online course that Microsoft currently have a available for free at https://www.microsoftelearning.com/sqlserver2005/default.aspx would be useful and applicable to SQL Server 2000, or whether it is sufficiently different product to make it confusing to use this as a learning resource.
Also if anyone can point me toward any webcasts for SQL Server that would be great. I listened to Fritz Onion's 15 part series when I studied for my ASP.NET exam and would like to do something similar for SQL Server 2000 if any are available.
View 3 Replies
View Related
Oct 7, 2005
Ok so i am thinking of get the Microsoft SQL server 2000 Developer Edition, i have some questions. - Does it include the server and tools?- What tools does it include? The same as the Enterprise Version?- Will it positively work on Windows XP Pro?- Will you need to install anything else? Does it come with the Microsoft Server Desktop Edition as the server or something?- Will this version allow me to use it to make databases for websites? I searched this forums but i can seem to find what "....it is prohitbited in production..." that means?Thank you and i have tried to search the forums but have gotten no real answers Hope you can read my questions clearly. Thanks!!!!
View 4 Replies
View Related
Apr 9, 2001
I recently wrote a white paper on OLAP and was having a hard time finding any information about what was new in SQL Server 2000 OLAP on the web. I didn't really find much until I downloaded a trial copy of SQL Server 2000 (which didn't have OLAP, but had links to information on it). We use Hyperion Essbase, and I was wondering if Microsoft OLAP 2000 would be a viable competitor.
View 2 Replies
View Related
Apr 17, 2007
Hi all,
This may be more of a Sharepoint or server question but I thought I would post it here to start off with. I have an installation of SQL 2000 SP4 and sharepoint services 2003 all on one server. For example the SQL 2000 (SP4), sharepoint and its indexes all on the one server (HP G4 DL380). I have installed the index service and the full text services on the SQL server then configured searching in sharepoint. The search worked fine for about a year until one day the server started randomly hanging for no apparent reason. After a hard reboot the server would begin to hand again after around 2-3 minutes of being online, sometimes less. After lots of problem shooting I nailed it down to being the Microsoft search service that caused the issue. Basically if I set this service to manual and boot I have no problem. As soon as I start the service the server will start to hang about 2-3 minutes later.
I tried this again last night after trying some fixed and got the same result. The only error I get are in the application log which are about 4 of these with different file types.
One or more documents stored in image columns with extension €œX€? did not get full-text indexed because loading the filter failed with error '0x1'
The server continues to log messages while it is hanging and you can ping the server but you can not access sharepoint, remote in to the server, you can login locally but as soon as you try anything like bring up the start menu all resources will freeze up. During this time there is no disk activity and the CPU usage is 1-3% and mem usage is low.
Can anyone suggest anything to fix this problem so I can start the Microsoft search service and use search in sharepoint again.
Thanks,
LS
View 2 Replies
View Related
Mar 28, 2008
Hey yall. I'm a DBA in a company where I do NOT have the ability tocontrol who logs into my SQL servers as administrator, so I'm lookingfor a way to uninstall the workstation components WITHOUT completelyuninstalling all of my instances. Does anyone know how to do this?All I can find is the complete removal option in add/remove, and theinstall cd setup doesn't have a remove function that I can find. Anyidea's?The reason for wanting to do this is so that every tom dick and harrythat logs in as administrator doesn't have the ability to just open EMand do what they please. I want to force people to log in fromanother box so I can get tighter control over who can access mydatabases. Any help is awesome, thanks!Joshua Austill
View 2 Replies
View Related
Nov 16, 2006
Hello Friends,
I have a problem with ASP.net with dynamic data transfer from asp page to microsoft sql server 2000. For example , I have asp
web page with one text field and a buttion.
When I click the buttion, the value entered in the text field should be transfered from the text field to database.
Kindly See the following section c# code .....
SqlConnection objconnect = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = objconnect;
cmd.CommandText = " select * from Table_Age where Age = @Age";
cmd.CommandType = CommandType.Text;
SqlParameter parameter = new SqlParameter();
parameter.ParameterName = "@Age";
parameter.SqlDbType = SqlDbType.VarChar;
parameter.Direction = ParameterDirection.Output;
parameter.Value = TextBox1.Text;
objconnect.Open(); // Add the parameter to the Parameters collection.
cmd.Parameters.Add(parameter);
SqlDataReader reader = cmd.ExecuteReader();
********************this section c# code is entered under the button control************************************
connection string is mentioned in the web.config file.
In the above c# code , I have a text field , where I entered the age , the value entered in the text field should be sent to
database. I have used SqlParameter for selecting the type of data should be sent from ASP.NET 2.0 to the microsoft sql server 2000. I am facing a problem
where I am unable to sent the random datas from a text field to the database server.
I have a created a database file in the microsoft server 2000.after the excution of the fIeld value is assinged to NULL in the main database i.e microsoft the sql server 2000.Can anyone help with this issue.My mail id phijop@hotmail.com- PHIJO MATHEW PHILIP.
View 1 Replies
View Related
Jul 20, 2005
HI!I have a little problem:I have change the administrator password (Windows 2003 Server) which MSSQL 2000 use to login.And now the SQL server can't stand up.What should I do?thx!gicio--Posted via http://dbforums.com
View 1 Replies
View Related
