dbTalk Databases Forums  

Proper DTS for ETL

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Proper DTS for ETL in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Elena
 
Posts: n/a

Default Proper DTS for ETL - 06-14-2006 , 09:43 AM






Hi,
I need to find smart solution for ETL with DTS based on MS SQL Server 2000.
Historical tables which I need to transfer to staging environment are huge. I
do not need to keep all historical data in the OLTP database after data
transfer task completion. How can DTS tasks be organized?
Thank you
Elena

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.