Q
Problem solve Get help with specific problems with your technologies, process and projects.

Creating a DTS package

I need to create a DTS package to be run daily to extract some records
from one database (SQL Server 7.0) and insert into a table in another
database (SQL Server 2000). These two databases are not in one location.
eg; Extract all active usernames for the previous day from database1 and
insert into a table in database2. This process is to be run once every day.
Please provide a sample and steps to create this DTS package using SQL EM.

  1. Open package designer.
  2. Define two connections.
  3. Create a data pump task.
  4. Define the data you want moved and where you want to put it.
  5. Save package.
  6. Right click package name and select schedule package.
This was last published in November 2004

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close