Customize data transfers with DTS and SQL Server

by | 03-16-07

Tags: screenshots, dts, sql, data, sql server, Excel spreadsheet, database, OLE DB, Microsoft SQL Server, toolbar, Microsoft Corp., sales, FTP, workflow, e-mail, Microsoft Excel, scripting language, authentication, DTS Designer, Databases, Storage, Microsoft Office, Office suites, SOFTWARE, Enterprise software, DATA MANAGEMENT, HARDWARE

3 comment(s)

DTS Designer

Next Image »

DTS is a set of related tools that enable you to manipulate or transform data from various sources. To create a DTS package, you can use the DTS wizards to move data. You can also use the more advanced DTS Designer, which lets you create a multitude of packages and workflows. You can connect to a data store, create tasks that allow you to FTP data, and create your own tasks using a scripting language. Adding DTS to your repertoire will bring a whole new dimension to your skill set.

In this screenshot gallery, Stephen Warren shows you how to customize data transfers with SQL Server and DTS.

To access the DTS Designer, open Enterprise Manager from the Start Menu, right-click on Data Transformation Services, and choose New Package.

Click each image for a full size version.