S D
sqlserver667 at yahoo.com
Wed Jun 23 02:29:12 CDT 2004
Hi, I'm not sure if it's clear now but: Client side => if you start a DTS package via EM the DTS runs on the client Server side => if you SCHEDULE a DTS package then the DTS runs on the server! Very easy to test: try reading/exporting to/from a file on the server. If you start the dts via EM Execute Package it cannot find the file! HTH Sander --- Michael_Brosdorf <michael.broesdorf at web.de> wrote: > Thank your for the insight! > If I have the time during the week I will use SQL > Profile to find out what > happens with > data transfer tasks. > > Michael > > -----Ursprungliche Nachricht----- > Von: dba-sqlserver-bounces at databaseadvisors.com > [mailto:dba-sqlserver-bounces at databaseadvisors.com]Im > Auftrag von Mike & > Doris Manning > Gesendet: Montag, 7. Juni 2004 11:57 > An: dba-sqlserver at databaseadvisors.com > Betreff: RE: [dba-SQLServer] DTS question > > > 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 > > > _______________________________________________ > 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 > __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail