Mike & Doris Manning
mikedorism at adelphia.net
Mon Jun 7 04:57:28 CDT 2004
If you are using EM on a client machine, then the DTS package is executing on the client machine and not the server. I discovered this because I have some packages that open an Access database and process a report. The packages fail if I'm not on the server itself because I hardcode the path to the database using the server's drive mappings. I believe that SQL contained in an Execute SQL Task is sent the server and processed there just like any other sproc or view. I believe a Transfer Data Task is reading all the data over the network to the client and then being processed. If my beliefs are incorrect, someone please speak up because I'd be very happy to be corrected on this. 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: Monday, June 07, 2004 4:29 AM To: dba-sqlserver at databaseadvisors.com Subject: AW: [dba-SQLServer] DTS question 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com