You may occasionally find yourself in the situation where you need to transfer a lot of data into your SQL Server database from another database or spreadsheet. Or, perhaps you need to export data from your database into another database or spreadsheet. In SQL Server, DTS makes this an easy task.
DTS (Data Transformation Services) is a set of graphical tools that allows you to transfer data between disparate sources into one or more destinations.
DTS Tools
SQL Server DTS includes the following tools, which enable you to create, schedule, and execute DTS packages.
Tool Description
DTS Import/Export Wizard Enables you to transfer data to and from a SQL Server database.
DTS Designer Enables you to build complex DTS packages containing workflow and event-driven logic. The DTS Designer can also be used to modify packages created with the DTS Import/Export Wizard.
DTS Run utility Allows you to schedule and run a DTS package.
dtsrun utility Allows you to run DTS packages from the command prompt and schedule them using batch files.
DTS Query Designer A graphical user interface that allows you to build SQL queries.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment