dcsimg
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: SQL Server
Expertise: Beginner
Nov 3, 1999

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


Integration of Replication and DTS Steps

Question:
I am trying to build a warehouse. The steps involved are:
  1. Make a snapshot replication of the OLTP onto the staging area.
  2. Run a DTS package that makes transformations and loads the data warehouse.
Since I want to automate the process, I want to schedule Step 1 and then, on its completion, start Step 2. Because Step 1 is in Replication module and Step 2 in DTS module of SQL Server 7, I am unable to integrate the two. How do I get this to work?

Answer:
I am not clear on what you are trying to accomplish. Replication, once it's defined on your OLTP system, should be running in a hands-off kind of way, not requiring you to initiate it. Either your Publisher is going to push it or your subscribers are going to pull it, but in no case should you be having to manage the updates yourself. That's up to your schedule and the log reader.

I think you need to revisit the goals of the process and iron out some duplication of tasks between the transformation services and replication.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date