[dba-SQLServer] DTS question

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





More information about the dba-SQLServer mailing list