Could any one please recommend some good books on sql server 2000 ETL best 
practices ??

I am trying to learn some best practices regarding this subject so any white
papers, articles, web sites, books would be greatly appreciated.

TIA...

sqlster,

Check out:

http://www.sqldts.com/

and

http://www.sqldts.com/default.aspx?400

HTH

Jerry
Show quoteHide quote

TechNet and MSDN have articles on the subject:
SQL Server 2000 Administrator's Pocket Consultant: Importing and Exporting
Data with DTS and BCP
http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c07ppcsq.mspx

Of course, you can find a slew of books on the technical aspects of using
SQL Server DTS specifically. However, if you are wanting to learn more about
best practices and ETL in general, then go to Barnes&Noble or Borders this
weekend and browse through these.

The Data Warehouse ETL Toolkit: Practical Techniques for Extracting,
Cleaning, Conforming, and Delivering Data
by Ralph Kimball, Joe Caserta

Building the Data Warehouse
by W. H. Inmon

Show quoteHide quote

Unknown Columns!
Simple query?
adding 140,000 records requires index rebuild. make sense?
Need advice with a query
Index Tuning Wizard