To be able to offer a more professional solution we would need to know what
you have done with your current implementation to know if you could do it
better.
As for books on DTS I personally liked Peterson (SAMS) SQL Server 2000 DTS.
It may well be that what you require is not natively provided by DTS per se
but you could write your own Custom tasks to fill the blanks.
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"Alexander Nenashev" <nenashev (AT) hotbox (DOT) ru> wrote
Quote:
after the first iteration (at least working) of my dts/etlm application
for a datawarehouse,
i decided to do the next step to more professional implementation.
is there a book, that covers etlm with a tendency to implementation with
dts?
currently i decided implement my next iteration with
ms bi accelerator, at least grab all stagging, logging, error handling
algorithms
from it.
any directions, links & tips are appreciated |