MS SQL Basics Tutorial: Basic concepts of data Transformation Services

In the process of using SQL Server, the export of data, import is an extremely common operation because of the frequent need to centralize data from multiple different locations or to replicate data to multiple locations. We can use the bcp command to do this, but remember that the command format for BCP is a pain in the neck, Although you can view the Help files, we need powerful and simple tools to do this, and Data Transformation Services DTS provides this support. So this chapter describes the basics of DTS, discusses the various building components of DTS, and how to complete the Data Transformation Services.

Introduction to 18.1.1 Data Transformation Services

To support enterprise decision-making, many organizations need to centralize data for analysis. But usually the data is stored in different places in different formats. Some may be text files, some of which have a table structure but do not belong to the same data source, which greatly hinders the centralized processing of data. SQL Server provides us with a comforting component, Data Transformation Services (DTS). DTS itself contains multiple tools and provides interfaces to enable the import, export, or delivery of data between any data sources that support OLE DB, and makes this work simple and efficient. This means that data can be dumped not only between SQL Server data sources, but also from Sybase, Oracle, and Informix, to SQL Server.

The use of Data Transformation Services (DTS) may import, export, or pass in information between any OLE DB, ODBC driver's data source, or text and SQL Server. The specific performance in: Data import, export services

Exchange data between different applications by reading and writing data. For example, you can import a text file or a Microsoft Access database to SQL Server, or export data from SQL Server to any OLE DB data source. converting data

Passing is a series of operations on data that is taken before the data source has reached the destination. For example, DTS allows new column values to be computed from one or more columns of the source data source, and then stores them in the destination database. Passing database objects