SQL Server 2000 DTS Designer Components
Overview
SQL Server 2000 DTS Designer Components is a software program developed by Microsoft. The most common release is 9.00.1399.06, with over 98% of all installations currently using this version. Upon being installed, the software adds a Windows Service which is designed to run continuously in the background. Manually stopping the service has been seen to cause the program to stop functing properly. It adds a background controller service that is set to automatically run. Delaying the start of this service is possible through the service manager. A scheduled task is added to Windows Task Scheduler in order to launch the program at various scheduled times (the schedule varies depending on the version). The software is designed to connect to the Internet and adds a Windows Firewall exception in order to do so without being interfered with. The setup package generally installs about 176 files and is usually about 523.91 MB (549,359,465 bytes). Relative to the overall usage of users who have this installed on their PCs, most are running Windows 7 (SP1) and Windows XP. While about 62% of users of SQL Server 2000 DTS Designer Components come from the United States, it is also popular in India and Greece.
Program details
Help link: go.microsoft.com/fwlink/?LinkId=52601
Installation folder: C:\Program Files\Microsoft SQL Server\
Uninstaller: MsiExec.exe /I{F582ABB6-BFD7-419C-9C0B-43CE27BF543E}
(The Windows Installer is used for the installation, maintenance, and removal.)
Estimated size: 523.91 MB
Language: English (United States)
Files installed by SQL Server 2000 DTS Designer Components
-
SAC.exe - Microsoft SQL Server Surface Area Configuration command line utility
-
sqlredis.exe - Microsoft(R) Windows (R) 2000 Operating System (Win32 Cabinet Self-Extractor)
-
msasxpress.dll - Microsoft SQL Server Analysis Services (Microsoft Compression Library)
-
msmdlocal.dll
-
SQLCMD.EXE - T-SQL execution command line utility
-
atl80.dll - Microsoft® Visual Studio® 2005 (ATL Module for Windows (Unicode))
-
dbghelp.dll - Debugging Tools for Windows(R) (Windows Image Helper)
-
mfc80.dll - MFCDLL Shared Library - Retail Version
-
MFC80CHS.DLL - MFC Language Specific Resources
-
MFC80CHT.DLL
-
MFC80DEU.DLL
-
MFC80ENU.DLL
-
MFC80ESP.DLL
-
MFC80FRA.DLL
-
MFC80ITA.DLL
-
MFC80JPN.DLL
-
MFC80KOR.DLL
-
mfc80u.dll
-
msvcp80.dll - Microsoft® C++ Runtime Library
-
msvcr80.dll - Microsoft® C Runtime Library
-
msxmlsql.dll - Microsoft(R) MSXMLSQL 1.0 RTM (MSXMLSQL RTM)
-
mssdi98.dll - Microsoft® Visual Studio (Microsoft® SQL Debug Interface)
-
autoplt.dll - Microsoft SQL Server (Auto Pilot - Index Tunning DLL)
-
autowiz.dll - SQLProfiler Autopilot wizard
-
axscphst.dll - AxScriptHost70 - Active Scripting Host for SQL
-
AXSCPHST90.DLL - AxScriptHost90 - Active Scripting Host for SQL
-
batchparser.dll - Batch Parser
-
batchparser90.dll
-
bcp.exe - BCP - SQL bulk copy tool
-
cdw.exe - OMW Wizard EXE
-
cdwtasks.dll - CDWTASKS - All OMW custom task are defined here.
-
cdwtskui.dll - CDWCTSKUI - All cdW custom task user interfaces are defined here.
-
comnevnt.dll - Common Event Model DLL
-
ctasksui.dll - CTASKSUI - All DTS custom task user interfaces are defined here.
-
custtask.dll - CustTask - DTS Custom Task implementation file.
-
DataCollectorTasks.dll - Data Collector Tasks
-
DataProfileViewer.exe - SQL Server Integration Services Data Profile Viewer
-
dcomscm.exe - SQL Server DCOM SCM Object
-
DISTRIB.exe - SQL Server Replication Distribution Agent
-
DTAttach.exe - SQL Server Integration Services Script Task
-
DTEParse.dll - Data Transformation Services Execution Utility Parser
-
DTEParseMgd.dll - Data Transformation Services Execution Utility Managed Parser
-
DTEPkg.dll - Data Transformation Services Execution Utility Package Processing
-
DTExec.exe - Data Transformation Services Execution Utility
-
DTS.dll - DTS - Data Transformation Runtime DLL
-
DTSComExprEval.dll - Data Transformation Services Expression Evaluator
-
DtsConn.dll - DTSCONN - Data Transformation Runtime Connections DLL
-
DtsDebugHost.exe - SSIS Debug Host
-
dtsffile.dll - DTSFlatFile Rowset Provider DLL
-
dtshost.exe - DTS - Runtime Surrogate
-
dtsinstall.exe - SQL Server Integration Services Package Installation Utility
-
DTSLog.dll - DTSLOG - Data Transformation Runtime Log Providers DLL
-
DTSMigrationWizard.exe - DTS Migration Wizard Utility
-
dtsmsg.dll - DTS - Messages
-
DTSPipeline.dll - DTSPipeline - Data Transformation Pipeline DLL
-
DTSPipelinePerf.dll - DTSPipelinePerf - Data Transformation Pipeline Performance Counters
-
dtspkg.dll - DTSPackage Service Provider DLL
-
dtspump.dll - DTSDataPump Service Provider DLL
-
dtsrun.exe - DTSRUN - DTS Package CommandLine Execution
-
dtsrunui.exe - DTSRUNUI - DTS Run User Interface
-
dtsui.dll - DTSTaskUI - UI Provider for all internal Custom Tasks
Behaviors exhibited
Scheduled Task
- SqlWtsn.exe is scheduled as a task with the class '{FBFEF622-33BC-46CD-BE7E-FD75573E261C}' (runs on registration).
3 Services
- sqladhlp90.exe runs as a service named 'MSSQLServerADHelper' (MSSQLServerADHelper) "Enables integration with Active Directories.".
- sqlwriter.exe runs as a service named 'SQLWriter' (SQLWriter) "Provides the interface to backup/restore Microsoft SQL server through the Windows VSS infrastructure.".
- sqlbrowser.exe runs as a service named 'SQL Server-Browser' (SQLBrowser) "Stellt Clientcomputern SQL Server-Verbindungsinformationen bereit.".
3 Windows Firewall Allowed Programs
- sqlbrowser.exe is added as a firewall exception for 'C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe'.
- SqlWtsn.exe is added as a firewall exception for 'C:\Program Files\Microsoft SQL Server\90\Shared\SqlWtsn.exe'.
- SqlSAC.exe is added as a firewall exception for 'C:\Program Files\Microsoft SQL Server\90\Shared\SqlSAC.exe'.
How do I remove SQL Server 2000 DTS Designer Components?
You can uninstall SQL Server 2000 DTS Designer Components from your computer by using the Add/Remove Program feature in the Window's Control Panel.
- On the Start menu (for Windows 8, right-click the screen's bottom-left corner), click Control Panel, and then, under Programs, do one of the following:
- Windows Vista/7/8/10: Click Uninstall a Program.
- Windows XP: Click Add or Remove Programs.
- When you find the program SQL Server 2000 DTS Designer Components, click it, and then do one of the following:
- Windows Vista/7/8/10: Click Uninstall.
- Windows XP: Click the Remove or Change/Remove tab (to the right of the program).
- Follow the prompts. A progress bar shows you how long it will take to remove SQL Server 2000 DTS Designer Components.
OS VERSIONS
Win 7 (SP1) 62%
Win 7 3%
|
|
HOW IT RUNS
Windows Service? Yes
(Installs a service)
|
|
USER ACTIONS
 |
Uninstall it 5%
Keep it 95%
|
|
Windows
Which Windows OS versions does it run on?
| Windows 7 |
64.86% |
|
| Windows XP |
21.62% |
|
| Windows 10 |
8.11% |
|
| Windows Vista |
5.41% |
|
Which OS releases does it run on? |
| Windows 7 Professional |
43.24% |
|
| Microsoft Windows XP |
21.62% |
|
| Windows 7 Enterprise |
10.81% |
|
| Windows Server 2008 R2 En... |
5.41% |
|
| Windows Vista Home Premiu... |
2.70% |
|
| Windows Vista Business |
2.70% |
|
Geography
62.00% of installs come from the United States
Which countries install it?
| United States |
62.00% |
| India |
10.00% |
| Greece |
6.00% |
| United Kingdom |
4.00% |
| South Africa |
2.00% |
| Colombia |
2.00% |
| France |
2.00% |
| Switzerland |
2.00% |
| PR |
2.00% |
| Israel |
2.00% |
| Canada |
2.00% |
| Czech Republic |
2.00% |
| Slovakia |
2.00% |
PC manufacturers
What PC manufacturers (OEMs) have it installed?
| Dell |
36.36% |
|
| Hewlett-Packard |
21.21% |
|
| Intel |
12.12% |
|
| American Megatrends |
9.09% |
|
| Lenovo |
9.09% |
|
| GIGABYTE |
3.03% |
|
| Acer |
3.03% |
|
| Compaq |
3.03% |
|
| Samsung |
3.03% |
|
Common models |
| HP Pavilion dv7 Notebook ... |
6.90% |
|
| Dell Precision WorkStatio... |
6.90% |
|
| Dell OptiPlex 990 |
3.45% |
|
| Dell OptiPlex 360 |
3.45% |
|
| HP EliteBook 8560p |
3.45% |
|
| HP Compaq 8200 Elite MT P... |
3.45% |
|
About Microsoft
Microsoft Corporation develops, manufactures, licenses and supports a variety of products and services related to computing.
Publisher URL: www.microsoft.com