Sunday, February 19, 2012

DTS, SMO, SSIS

Database Transfer Services, replaced now by SMO now as I know..
In SQL Server 2005 is SSIS (SQL Server Integration Services).From Microsoft web page:SQL Server Integration Services, or SSIS, is an engine for building data import and export solutions and performing transformations on data as it is transferred.
 
 
pls. explain SSIS than? what is latest technology?

SSIS is the new, and very much improved, DTS.

SMO, or SQL Managment Objects, are used to automate common SQL Server functions, I believe...

No comments:

Post a Comment