A DTS package is executed from whereever you say "go"
So say you have a package on an NY server that pumps data to Seattle. In EM
you connect to the NY Server from London, look at the package, right click
on the package and press Execute.
The data will come from NY ---> London ---> Seattle
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Nanette" <anonymous (AT) discussions (DOT) microsoft.com> wrote
Quote:
I have a DTS package that takes tables from a db server and creates tables
and copies data into an Access db on another server. I'm running the VB code
|
from my desktop.
Quote:
My question is: Where is the DTS process actually running? Once it hits
the .Execute line, is the db server controlling it or my desktop? The reason
|
I'm asking is that the process takes longer than I'll be connected to the
network. And I don't have access to any of the servers to run the process
remotely. When I pull my laptop off later, is it going to halt the DTS
execution?
Re: Where is the processing point? -
04-14-2004
, 10:52 AM
Linear Mode
