.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Server DTS Designer Components installed but can not find on the computer

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server


I am in urgent need of help.

I have MS Access database to be converted into the SQL Server database.

Now I downloaded and installed MS SQL Server 2005 Management Studio and connected to the SQL Server database.

Now, I have to import the Access data in SQL server through SQL Server 2000 Import/Export client tool, for which I installed SQL Server 2000 DTS Designer COmponent.

I was able to install in the computer but I can not find any component on my computer.

I checked C:\Program Files\Microsoft SQL Server\90\    but I did not find any DTS\Binn\Dts*.exe there.  I do not know how and where to start the wizard to get the Import/Export utility.

I also checked in explorer Start->All Programs , menu but only See MS SQL Server 2005 and nothing related to DTS.


Please let me know what should I do and where to look for the components on my computer.



View Complete Post

More Related Resource Links

Getting Sql Server Management Studio 2008 installed on local computer

Hello, I have been trying to figure out this problem for a while now so hopefully someone can help me out - I would really appreciate it! Right now I have SQl Server Management Studio2005 installed on my computer for a SQL sever that we have. We recently got a 2008 sql server and if I remotely access the server, I can see that SQL Management Studio 2008 has been isntalled on the new server. I need to build new databases but need SQL Management Studio 2008 on my computer and I have no idea how to get it. I have a "Microsoft SQl Server 2008 R2" folder on my computer, and I have already tried clicking on "Configuration Tools" and then "SQL Server Installation center" and it isntalls a bunch of things, but none of them are "SQL Server Management Studio 2008."  I also found a link on a Microsoft website that says it's SQL Server Management studio 2008 R2 but it was just the same bunch of programs I already downloaded. How do I install Sql Server Managment Studio 2008 on my computer?! Thanks in advance for any help you can provide.

SQL2005 x64 on Windows Server 2008 x64 - One or more of the components being installed are already r


Failed to install and configure assemblies E:\Program Files_64bit\Microsoft SQL Server\90\DTS\Tasks\Microsoft.sqlServer.MSMSTask.dll in the COM+ catalog.
Error -2146233087. Error message: Unknown error 0x80131501
Error Description: One or more of the components being installed are already registered as 32 bit components in the target application.
(a) You must install the 64 bit versions of the components being installed in a different COM+ application,
(b) delete the existing 32 bit versions of the components being installed from the target COM+ application prior to attemping install of the 64 bit versions.
COM+ applications cannot contain bit neutral components.
Copied From installation Summary
<Func Name='LaunchFunction'>
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlAssemblyRegSvcs
PerfTime Start: Do_sqlAssemblyRegSvcs : Mon Sep 14 14:35:26 2009
<Func Name='Do_sqlAssemblyRegSvcs'>
Failed to install and configure assemblies E:\Program Files_64bit\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog.
Error: 2148734209
Error message: Unknown error 0x80131501
Error descrition: One or more of the components being installed are already registe

How to find SQL Server instances installed?


Hi there.

I want to connect to database from my application.

I dont't know what's the name of installed instance of sql server 2005.

I tried pcname and (local) and local host ...

How can I aquire the name?

Determine whether Forms Server is installed on a server

Check whether the Microsoft.Office.InfoPath.Server.dll and FormServer.aspx files are installed on the server.

LDAP - Can't find server


Hey people,

I would like to get a persons name from their username - a common query on forums i know, but i haven't managed to get mine working yet and any help would be appreciated.

I currently have this code that I found here: http://www.vbforums.com/showthread.php?t=612655 (Thanks Chris128)

I have adapted it from VB into VB.net. The page renders but when i enter my username into the Username textBox and hit the submit button (Which calls IsUser) I just get "The specified domain either does not exist or could not be contacted." I have tried lots of other code but I always get this response...

If anyone can help by posting links to a tutorial or another post for code that they know works, i will give it a go.


Imports System.DirectoryServices

Partial Class UserInfo
    Inherits System.Web.UI.Page

    Private Function GetRealNameFromAd(ByVal UsernameToFind As String) As String
        Using searcher As New DirectorySearcher(New DirectoryEntry())
            searcher.PageSize = 1000
            searcher.SearchScope = SearchScope.Subtree
            searcher.Filter = "(&(samAccountType=805306368)(sAMAccountName=" & UsernameToFind & "))"
            Using Results A

Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

TSWebAccess Webpart can't find Terminal Server


a. Windows Server 2008 with TS Web Access installed and MOSS 2007

b. Windows Server 2008 R2 in Remote Desktop Services installed and configured.

The SharePoint web part is installed and I an add the web part in the site. But when I try to add the terminal server name I get:

TS Web Access was not able to access the specified terminal server. Verify that the computer account of the TS Web Access server is added to the TS Web Access Computers security group on the terminal server.

Any ideas why this is happening.  I saw other threads with the same error and no answer yet, so I guess I'm not the only one having the problem.




Costas Tsaklas - http://costas.cpstechgroup.com

Sharepoint server not installed error

Hi geeks,               Actually I installed Sharepoint server ie., MOSS 2007 in system (Windows server 2003) and am using Visual studio 2010 ultimate. When am add new Sharepoint connection to my Visual studio 2010 it throws me error "A Sharepoint server is not installed on this computer. A Sharepoint must be installed to work with Sharepoint projects.".               I don't know what to do with it. Can you guys help me out to access my sharepoint site to my VS 2010.    Thanks, Karthick.

SQL Server Express 2008 Setup fails. Support Rule "Restart Computer" Failed

Hi, I have been trying to install SQL Server Express for most of the day now without any luck.  Whatever I do setup fails at the stage of Setup Support Rules, Rule "Restart Computer" - Failed.  Needles to say I have restarted (several times!) and I have tried downloading  and installing the "Advanced", "Tools" and "Basic" versions, all give the same error.  Trying a repair does the same.  I have been searching the net for an answer without success, any help would be MUCH appreciated. Further info: I am trying to install a stand-alone installation on to a single PC running under XP SP 3 with .NET 3.5 SP1 installed.  The PC did have some earler versions of SQL server installed but I (?hopefully?) removed all of these through Control Panel.  Before trying the first SQL install I installed Windows installer 4.5 and PowerShell 1.0 as per the Microsoft Instructions. Running SQL Server Configuration Manager results in an error (MMC could not create the snap-in. The snap in might not have been installed correctly).  A directory structure for SQL server exists in "Program Files".  Services MSC shows SQL Server (SQLEXPRESS) as Automatic Statup (not running).  Trying to start this manually gives error 14001: "application configuration incorrect - re-install to fix" .......... Which is precisely what I'm trying to do.........:(

Detect other versions of SQL Server, or SQL server instances on a computer

Hi All, I want to detect other versions of SQL Server, or SQL server instances on a computer. I used the recommended Microsoft C# example by using the SQL Server Windows® Management Instrumentation (WMI) provider. http://msdn.microsoft.com/he-il/library/dd981032(en-us,SQL.100).aspx SQL server 2005 has been correctly identified on my PC with Windows 7 64 bit OS. Then I uninstalled the SQLserver and all its tools/components. But even after uninstall the utility detects the SQL server 2005 as if it was not removed. What is an alternative for the correct detection of the SQL server installed on PC? Thanks in advance Dmitry

installed ms sql server 2008 and there is no db instance

I had the 2005 version on installed on my pc...I installed visual studio 2010 professional but the sql 2005 did not work. I tried to install sql 2008 but I was unable to. Searched on the web and found out that I had to uninstall sql 2005 for some reason. I did. I successfully installed sql 2008 now but there is no database instance. I tried sqlcmd -L and there where no servers available.   Can I install I new instance now? How can I do that?

Where to find the latest list of critical SQL Server fixes?

Hi, Where can I find the latest list of critical SQL Server fixes?

"designer" problem- can't find the files

i got a project (.NET website) from another developer, unlike my project, every page has three parts- the aspx page, the cs page and a "designer" page. i tried to run the web site but i get error problem- "could not load .... type", it looks like the builder can't connect the designer file to the right page. how can i solve the problem can i link the page and the designer...

Connect SQL Server 2005 to Ms Access on another computer

I'm trying to create a "Linked Server" on my SQL Server 2005.  This linked server is a reference to an Access File on a remote computer.  I've set up all the permissions and shared resources.  I've created an ODBC DSN to connect to the database.  If i open the DSN in excel, i can retrieve data.  If I open a linked server connected to the DB I get the following error when i try to run a query against it.   ------------------ OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'.  It is already opened exclusively by another user, or you need permission to view its data.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LS_Specialty". ---------------------   Why does this DSN work in Excel and Access, but not in SQL

How can find computer accounts or computer owner via C# in active directory via ldap?

Hi any body.Is there any way to find computer owner or computer accounts in activedirectory via ldap?I wanna to know if it is possible via ldap or another way?I using c#.Thanks for any help.

Do SharePoint 2007 and VS2010 have to be installed to the same Windows Server machine?

For WSS 3.0 development using VS 2005, I learned that we need to install VSeWSS to the Windows Server where the WSS 3.0 was installed.  For MOSS 2007 development using VS 2010, do we need to have VS 2010  nstalled to the same Windows Server?  Thanks, Jeffrey

Linked Server to DB2 from SQL 2005 IA64BIT computer

Has anyone created a linked server to DB2 on AS/400 from SQL Server 2005 IA64 BIT? We were hoping to use the new Microsoft OLEDB Provider for DB2...The problem is the driver looks like it will only work on x64 computers."The single setup program will install the provider and tools on both x86 and x64 computers" We were able to install the driver on the IA64 computer and were able to successfully create a data source from the Data Access Tool. Oddly enough when we attempted to create a linked server in SSMS we received an error, we also noticed that the DB2OLEDB provider is not listed in SSMS. This is becoming a real problem so any ideas on how we can get this driver to work or suggestions on an alternative would be greatly appreciated.   thx.art.  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend