I am confused on what drive letters a package accesses.

For example, I have a computer that I am access using terminal server. The
C drive is mapped to my X drive. I am creating a package on the server and
storing it on the server.

I have an excel file that I am accessing to populate a table. It is on the
C: drive of the SQL Server (my X: drive). The problem is I have to tell the
package that the drive the file is on - is the X: drive or the DTS designer
won't allow it. I wanted it on the C: drive, as the package may be run from
another machine which may not have the drive designated C:

If I run the DTS package from the terminal server, is the package actually
running from SQL Server, or the workstation on the terminal server (which I
have SQL Enterprise Manager on and am running the package from).

Thanks,

Tom.

The package runs wherevere you are running Enetyrprise Manager, or DTSRUn or
whatever the calling application is.

So if I run TS and then run EM inside TS, it is running on the machine I am
connected to over TS.

The exception to this is the Bulk Insert task which *always* uses file paths
local to the server.


--
Darren Green
http://www.sqldts.com

"Thomas Scheiderich" <tfs (AT) deltanet (DOT) com> wrote