What are the enhancements in Data Transformation Services (DTS)?
The new DTS designer is now integrated into the Microsoft Visual Studio Development Environment, which now provides one single integrated development experience to perform Data transformation functions with Yukon. This now enables and integrates with SourceSafe for version control. The new DTP engine now provides support for data flow between multiple sources, multiple transformations and multiple destinations. Now the new engine supports several new transformations such as Multicast Transformation, Conditional Split Transformation, Sort and Lookup Transformation etc. Long needed deployment mechanism is featured in Yukon. Now a DTS package can be extracted from the Development database and exported after analyzing all dependencies before the package can be deployed on to the production server. 13. What are the enhancements that would help a SQL Server Yukon database administrator (DBA)? Yukon significantly enhances the existing Log shipping feature by providing a Database mirroring opt
Related Questions
- How should I handle mismatched SQL Server logins? Can you explain the differences between Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)?
- Can we use Import and Export Wizard or Data Transformation Services (DTS) with SQL Server 2005 Express Edition?
- What is Data Transformation Services?
