QUESTION POSED ON: 05 November 2004 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.
>
EXPERT RESPONSE
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.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.
