Mike & Doris Manning
mikedorism at adelphia.net
Thu Jun 3 06:10:49 CDT 2004
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