Packages in SQL Server

[Anna]

Hi: Can any one please tell me about Packages and their use in SQL
Server?

Thanks,
Anna

[Erland Sommarskog]

Anna (co*********@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[DA Morgan]

Erland Sommarskog wrote:

Anna (co*********@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.

Unless the question is being asked from the perspective of someone that
has worked in Oracle in which case they do not exist.
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org