Data Management

Customize data transfers with DTS and SQL Server

Create a new package

Let's create a package that will do the following:

  • Query our sample pubs database for a list of authors and their year-to-date sales
  • Save the results to an Excel spreadsheet
First, open the DTS Designer and add the Microsoft OLE DB Provider For SQL Server connection. Specify the pubs database and the authentication method.

About

Bill Detwiler is Managing Editor of TechRepublic and Tech Pro Research and the host of Cracking Open, CNET and TechRepublic's popular online show. Prior to joining TechRepublic in 2000, Bill was an IT manager, database administrator, and desktop supp...

0 comments