Packages in SQL Server

Anna

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

Thanks,
Anna

Jan 11 '07 #1

Subscribe Post Reply

13640

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

Jan 11 '07 #2

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

Jan 12 '07 #3

by: Chung Leong | last post by:

I've been trying to set up a LAMP server for experimental purpose. Our production environment is WAMP (Windows Apache2 MSSQL PHP) but out of curiosity I would like to see if we can operate our...

PHP

Python COM server

by: Dave | last post by:

I have been trying an example from the Python Programming on Win32 book on the lastest versions of python (2.3.3) and win32all (build 163). I create the COM object and try to call it from VB but i...

Python

COM server being passed an instance of an interface

by: Phil | last post by:

I am using a Pascal like language (Wealth-Lab) on W2K and call this server: class HelloWorld: _reg_clsid_ = "{4E797C6A-5969-402F-8101-9C95453CF8F6}" _reg_desc_ = "Python Test COM Server"...

Python

DBI and DBI::Oracle packages configuration

by: ulloa | last post by:

Hi. My name is Randall and I am from Costa Rica. I have a little problem. I did an application using Perl, DBI and DBI::Oracle, and now I have to upload my application in an Unix server. The...

Perl

How to Migrate DTS packages between servers

by: Philip Yale | last post by:

I'm quite new to DTS, and have to modify a number of existing local DTS packages as part of an ongoing development project. Naturally, I'm doing these on a test server first, but so far I've...

Microsoft SQL Server

Installation of IBM DB2 Enterprise server edition on Linux

by: srihari | last post by:

Hai, I am trying to install IBM DB2 8.1 on Red Hat linux 8.0. My machine is Intel XEON 64bit. The installation went well except for the creation of tools catalog. When I tried to install the tools...

DB2 Database

mod_python, COM, on win2k3 server

by: | last post by:

I have an application that runs on mod_python/apache using the publisher handler. It uses an access db as the backend and connects via ADO. In a test environment on XP it runs fine, but when on a...

Python

How to stop an [Rpyc] server thread?

by: Saizan | last post by:

I embedded an Rpyc threaded server in a preexistent daemon (an irc bot), this is actually very simple; start_threaded_server(port = DEFAULT_PORT) then I had the necessity to stop the thread which...

Python

OLEDB configuration when deploying multiple SSIS packages

by: Jocky Mac | last post by:

I have an SSIS package which calls many other SSIS packages. Each of these was created with the import wizard in SSMS. As a result, they all have SourceConnectionOLEDB and...

Microsoft SQL Server

Migrating DTS Packages from SQL server 2000 to SQL server 2005

by: cathy25 | last post by:

Hi, we are planning on migrating our sql from version 2000 to 2005 (I know SQL 2005 is in market from a while). As a part of testing, i have installed sql server 2005 on my development box and able...

Microsoft SQL Server

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Energy Model code modification to account for year dependent interest rate

by: giovanniandrean | last post by:

The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...

Python

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

Report value list

by: Teri B | last post by:

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA

Take a Database to the Next Level

by: GKJR | last post by:

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

Microsoft Access / VBA

Similar topics