Discover the best practices for using DTS within the Data Warehousing Framework to capture and present data as Business Intelligence solutions. Business Intelligence (BI) solutions such as Data Marts and Data Warehouses rely heavily on tools to migrate data between heterogeneous data sources and support consolidated analytical decision-making. Microsoft SQL Server 2000 Data Transformation Services (DTS) provides the flexibility and advanced functionality to automate the architecture by which operational data is captured and delivered to the end-users of BI applications. The flexibility found within the DTS platform provides for a multitude..
