Customize data transfers with DTS and SQL Server

by Bill Detwiler  |  March 16, 2007, 3:26pm PDT  |  Image 4 of 9

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.

Create a new package - Image 4 of 9

Related Galleries

Bill Detwiler

About Bill Detwiler

Bill Detwiler is Head Technology Editor of TechRepublic. Previously, he worked as a Support Tech and IT Manager in the social research and energy industries.

Bill Detwiler

Bill Detwiler
Bill Detwiler is Head Technology Editor for TechRepublic. Previously he worked as a Technical Support Associate and Information Technology Manager in the social research and energy industries. Bill is a Microsoft Certified Professional with experience in Windows administration, data management, desktop support, and system security.

Bill Detwiler

Bill Detwiler
Bill Detwiler has nothing to disclose. He doesn't hold investments in the technology companies he covers.
2
Comments

Join the conversation!

Follow via:
RSS
Email Alert