What did Microsoft rename DTS to for SQL Server 2005 Express Edition?
Where is the download link to the SQL Server 2005 Express Edition DTS utility?
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.
DTS is not longer available in it's pure form in SQL Server 2005 and above.
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).
For instructions on how to "migrate" DTS packages to SSIS refer to the following Microsoft Books Online Reference: Migrating Data Transformation Services Packages
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.
