• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part V: SQL Server/MSDE Administration > Data Transformation Services

Chapter 22. Data Transformation Services

Data Transformation Services (DTS) is a comprehensive package for importing and exporting data. DTS allows transport of data between two data sources using open database connectivity (ODBC) or object linking and embedding database (OLE DB). It also allows the data to be converted and transformed during import or export. You can also use DTS packages to carry out complex, multilevel data transfers that can be started at specified points in time.

Microsoft SQL Server Enterprise Manager provides the DTS Editor, which you can use to create and process DTS packages. This feature is described later in this chapter.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint