What did Microsoft rename DTS to for SQL Server 2005 Express Edition?
Microsoft将DTS重命名为SQL Server 2005 Express Edition的内容是什么?
Where is the download link to the SQL Server 2005 Express Edition DTS utility?
SQL Server 2005 Express Edition DTS实用程序的下载链接在哪里?
i've been searching for half an hour, and i can't find a definitive answer.
我一直在寻找半个小时,我找不到明确的答案。
i need to import data from a data source into an SQL Server 2005 Express Edition database.
我需要将数据从数据源导入SQL Server 2005 Express Edition数据库。
3 个解决方案
#1
DTS is renamed SSIS and SSIS is not part of Express editions.
DTS重命名为SSIS,SSIS不是Express版本的一部分。
#2
DTS is not longer available in it's pure form in SQL Server 2005 and above.
在SQL Server 2005及更高版本中,DTS不再以纯格式提供。
A new technology platform called SQL Server Integration Services (SSIS) was developed and has replaced the functionality previously on offer via Data Transformation Services (DTS).
开发了一种名为SQL Server Integration Services(SSIS)的新技术平台,并取代了之前通过数据转换服务(DTS)提供的功能。
For instructions on how to "migrate" DTS packages to SSIS refer to the following Microsoft Books Online Reference: Migrating Data Transformation Services Packages
有关如何将DTS包“迁移”到SSIS的说明,请参阅以下Microsoft联机丛书参考:迁移数据转换服务包
#3
If you install Microsoft SQL Server 2005 Backward Compatibility Components you will have get the DTS stuff even on SQL Server 2005 Express. It will then be in c:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn or similar. DTSWizard.exe is probably what you are looking for.
如果您安装Microsoft SQL Server 2005向后兼容性组件,即使在SQL Server 2005 Express上也可以获得DTS内容。然后它将在c:\ Program Files(x86)\ Microsoft SQL Server \ 90 \ DTS \ Binn或类似文件中。 DTSWizard.exe可能是您正在寻找的。
#1
DTS is renamed SSIS and SSIS is not part of Express editions.
DTS重命名为SSIS,SSIS不是Express版本的一部分。
#2
DTS is not longer available in it's pure form in SQL Server 2005 and above.
在SQL Server 2005及更高版本中,DTS不再以纯格式提供。
A new technology platform called SQL Server Integration Services (SSIS) was developed and has replaced the functionality previously on offer via Data Transformation Services (DTS).
开发了一种名为SQL Server Integration Services(SSIS)的新技术平台,并取代了之前通过数据转换服务(DTS)提供的功能。
For instructions on how to "migrate" DTS packages to SSIS refer to the following Microsoft Books Online Reference: Migrating Data Transformation Services Packages
有关如何将DTS包“迁移”到SSIS的说明,请参阅以下Microsoft联机丛书参考:迁移数据转换服务包
#3
If you install Microsoft SQL Server 2005 Backward Compatibility Components you will have get the DTS stuff even on SQL Server 2005 Express. It will then be in c:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn or similar. DTSWizard.exe is probably what you are looking for.
如果您安装Microsoft SQL Server 2005向后兼容性组件,即使在SQL Server 2005 Express上也可以获得DTS内容。然后它将在c:\ Program Files(x86)\ Microsoft SQL Server \ 90 \ DTS \ Binn或类似文件中。 DTSWizard.exe可能是您正在寻找的。