Browse DevX
Sign up for e-mail newsletters from DevX

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



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

Integration of Replication and DTS Steps

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?

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.



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