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.
- Open package designer.
- Define two connections.
- Create a data pump task.
- Define the data you want moved and where you want to put it.
- Save package.
- Right click package name and select schedule package.