Posted by DA Morgan on 01/12/07 01:20

Erland Sommarskog wrote:
> 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.

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
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

[Back to original message]