[dba-SQLServer] DTS question

I have run DTS packacges both from my desktop and on the server.  I do not
think that DTS packages are set to run a particular place.  Most people
schedule them using the scheduler in SQL and in that case, they are running
on the server.

Debbie

-----Original Message-----
From: Michael Brosdorf [mailto:michael.broesdorf at web.de] 
Sent: Thursday, June 03, 2004 2:45 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] DTS question


Hi all

I am a little confused about where exactly DTS packages run.

Do they run on the SQL Server machine or do they run on the machine where I
use EM? And does it make a difference, if I use EM or call the packages from
within my Access FE (using the DTS Package library)?


Michael


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com
- JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject
to the Attorney-Client Privilege, (2) an attorney work product, or (3)
strictly confidential. If you are not the intended recipient of this
message, you may not disclose, print, copy or disseminate this information.
If you have received this in error, please reply and notify the sender
(only) and delete the message. Unauthorized interception of this e-mail is a
violation of federal criminal law. 
This communication does not reflect an intention by the sender or the
sender's client or principal to conduct a transaction or make any agreement
by electronic means.  Nothing contained in this message or in any attachment
shall satisfy the requirements for a writing, and nothing contained herein
shall constitute a contract or electronic signature under the Electronic
Signatures in Global and National Commerce Act, any version of the Uniform
Electronic Transactions Act or any other statute governing electronic
transactions.