468,278 Members | 1,580 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,278 developers. It's quick & easy.

Packages in SQL Server

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

Thanks,
Anna

Jan 11 '07 #1
2 13435
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
Jan 11 '07 #2
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
Jan 12 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Chung Leong | last post: by
reply views Thread by Dave | last post: by
1 post views Thread by ulloa | last post: by
1 post views Thread by | last post: by
3 posts views Thread by Saizan | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
1 post views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.