Posted by Erland Sommarskog on 01/11/07 21:55

Anna (colleen1980@gmail.com) writes:
> Hi: Can any one please tell me about Packages and their use in SQL
> Server?

Packages are specific to the area of DTS (Data Transformation Services)
in SQL 2000 and SSIS (SQL Server Integration Services) in SQL 2005. SSIS
is the successor to DTS. Both DTS and SSIS permits you receive files and
transform them before you load them into SQL Server. Exactly how, I don't
really know, because I have not used any of them.

Some people, particularly those that maintain a data warehouse which
receives data from all over the place, work a lot with DTS/SSIS, but if
you like me spend your time with an OLTP system, you may never get that
far.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]