Integration of Replication and DTS Steps

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.

Share the Post:
data observability

Data Observability Explained

June 8, 2023

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

June 1, 2023

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

May 24, 2023

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

Show More