Home >Backend Development >PHP Tutorial >Edit SQL Server 2000 DTS_PHP tutorial in SQL Server 2005

Edit SQL Server 2000 DTS_PHP tutorial in SQL Server 2005

WBOY
WBOYOriginal
2016-07-13 17:02:06955browse

Today, in order to experience the new functions of SQL Server 2005, I decided to kill the local SQL Server 2000, installed a SQL Server 2005, and experienced many new functions. At this time, I suddenly remembered that there are still some DTS improvements that need to be done. It was not completed, so I used SQL Server Management Studio to connect to the SQL Server 2000 server and opened the DTS package. When I was about to edit it, an error message appeared: Editing the DTS package requires the SQL Server 2000 DTS Designer component. To use this feature, please install the special WEB download file "SQL Server 2000 DTS Designer Component". In other words, SQL Server Management Studio of SQL Server 2005 cannot edit DTS 2000 (DTS of SQL Server 2000) by default. To solve this problem, Microsoft has added a patch for users to download. After installing this patch, you can edit DTS packages like SQL Server 2000.
SQL 2000 DTS tools are now available as part of the -
Download details: Feature Pack for SQL Server 2005 Nov 2005
(http://www.microsoft.com/downloads/details.aspx?familyid =D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en)
The direct link to the MSI-
http://www.microsoft.com/downloads/info.aspx?na=46&p=16&SrcDisplayLang=en&SrcCategoryId= &SrcFamilyId=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&u=http://download.microsoft.com/download/4/4/d/44dbde61-b385-4fc2-a67d-48053b8f9fad/SQLServer2005_DTS.msi&oRef=http:// forums. microsoft.com/MSDN/ShowPost.aspx?PostID=126513&SiteID=1


www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631098.htmlTechArticleToday, in order to experience the new features of SQL Server 2005, I decided to kill the local SQL Server 2000 and install it. I bought a SQL Server 2005 and experienced many new features. At this time...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn