Michael Brosdorf
michael.broesdorf at web.de
Mon Jun 7 03:28:40 CDT 2004
Does that mean that the SQL contained in an Execute SQL Task is sent to the server and processed there? How about Transfer Data Tasks? Is all data read over the network to the client machine? Michael -----Ursprungliche Nachricht----- Von: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]Im Auftrag von Mike & Doris Manning Gesendet: Donnerstag, 3. Juni 2004 13:11 An: dba-sqlserver at databaseadvisors.com Betreff: 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