Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ETL using DTS

Status
Not open for further replies.
anirudhadeo

anirudhadeo

Programmer
Mar 25, 2002
11
0
0
IN
Hi,
I am trying out for Extraction transformation and loading process for the dataware house but i am not being able to generate some logical steps for updates and deletes in the source database.
Like suppose if there are updates in the source database how can we make sure that only updated rows are selected and transferred to the dataware house tables. Is it possible through DTS
Regards Anirudha
 
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
117
Mike Lewis
Mike Lewis
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
86
Auguy
Auguy
BTrees
  • Locked
  • Question
Implement Encryption in Data Warehousing (ETL)
Replies
0
Views
26
BTrees
BTrees
Niki_S
  • Locked
  • Question
Create view using two databases
Replies
4
Views
80
Chris Miller
Chris Miller
EM1107
  • Locked
  • Question
Copy folder and content using SQL Server TSQL.
Replies
6
Views
103
RobertPhillips
RobertPhillips

Part and Inventory Search

Sponsor

Back
Top