[dba-SQLServer] DTS question

I think that Network Traffic - ie.Speed of transfer may be an issue.

Only noticed this when EM was on lap top using dial up. - Transformation was
not too speedy to say the least.
Presume files were going via my dial up connection.

Very new to DTS so only more than willing to be corrected.


john

-----Original Message-----
From: Mike & Doris Manning [mailto:mikedorism at adelphia.net]
Sent: 03 June 2004 12:11
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] DTS question


DTS packages run on the machine where you use EM.  Basically they make
activity requests of SQL Server just as if you were asking it to run a
stored procedure or view.

The only time I have noticed it making a difference where the DTS package
was run from is in the case of a process that needs to use a file in a
particular drive.

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Michael
Brosdorf
Sent: Thursday, June 03, 2004 3: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


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


The contents of this email and any attachments are sent for the personal attention
of the addressee(s) only and may be confidential.  If you are not the intended
addressee, any use, disclosure or copying of this email and any attachments is
unauthorised - please notify the sender by return and delete the message.  Any
representations or commitments expressed in this email are subject to contract. 
 
ntl Group Limited