SQL Server Data Transformation Services small coup

The following articles are mainly about the 4 magical uses of SQL Server Data Transformation Services to perform some automated operations. In the actual operations management of the SQL Server database , the database administrator wants the database to be able to collect information automatically and send it to the user's designated location such as mail, and so on.

In the Data Transformation task, a series of similar tools are provided to simplify the work of the database administrator. If you are interplanting in a DTS group, there is a tool for sending mail. With the relevant settings, the database automatically sends an e-mail message to the database administrator when the package succeeds or fails, reminding him of the success or failure of the job. A more detailed information is attached to the database administrator for subsequent operations.

The data conversion feature also includes an execution package task, and one package runs another as a package step. This can make our work more automated. As part of the database import process, we can run the plan through the package and write the data sheets that need to be imported sequentially into the execution package plan. And let the database in a relatively idle time, automatically import data in sequence. The database administrator does not have to command the side.

It can be seen that Data transformation service is a very powerful service. In the process of data import and conversion, the author has the most to do with this tool. Especially in the case of large amount of data, this data conversion service can indeed play the role of finishing touch.

The above is an introduction to some of the four tricks of the SQL Server Data Transformation Service to perform some automated operations, and I hope you can reap the rewards.

The above is a description of some of the four wonderful examples of automating operations performed on SQL Server Data Transformation Services, hopefully giving you some help in this regard.