DTS Package

Hi All,
I created a SQL Server DTS package when connecting to the SQL server on my
machine. We have a batch file created which was scheduled to run every Tue.
night on the server where SQL server really sits. In the batch file, we use
dtsrun to call this package. It has been running well. I shut my computer
down this Tue. after work. I got an error message from running the package.
Step Error Source: Microsoft JET Database Engine
Step Error Description:'I:\68\data_from_county' is not a valid path. Make
sure that the path name is spelled correctly and that you are connected to
the server on which the file resides.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:5003044
Should the package be run on the server? It should have nothing to do with
my computer, right? I got very confused. Any help will be greatly
appreciated.
CindyTry using a UNC path name to the file rather than a mapped
network drive...e.g.
\\ServerName\ShareName\date_from_country
In terms of the rest of your question, I'm not clear how you
are running the package. In terms of where you run it, that
depends. When you run a package manually, it runs under your
security context and from your PC. If you schedule it on
your PC, it runs from your PC and under the security context
you set in the scheduler. If you run it as a scheduled job
on SQL Server, it runs under the security context of the SQL
Agent service account (if the job is owned by a sysadmin)
and from the server.
For all of those different scenarios, you'd really want to
be using a UNC path as finding the file won't be dependent
on a profile's mapped drive, it won't matter if you execute
it from your machine or the server, etc.
In terms of the security issues, that will depend on the
security context used based upon how you are executing the
package. It sounds like you have permissions to the file. If
you schedule the package to run as a job on SQL Server, then
the SQL Agent service account will need to be a domain
account with appropriate permissions, access to the server
and file.
-Sue
On Fri, 20 Aug 2004 09:33:33 -0500, "Cindy"
<cindyhe@.bonestroo.com> wrote:

>Hi All,
>I created a SQL Server DTS package when connecting to the SQL server on my
>machine. We have a batch file created which was scheduled to run every Tue.
>night on the server where SQL server really sits. In the batch file, we use
>dtsrun to call this package. It has been running well. I shut my computer
>down this Tue. after work. I got an error message from running the package.
>Step Error Source: Microsoft JET Database Engine
>Step Error Description:'I:\68\data_from_county' is not a valid path. Make
>sure that the path name is spelled correctly and that you are connected to
>the server on which the file resides.
>Step Error code: 80004005
>Step Error Help File:
>Step Error Help Context ID:5003044
>Should the package be run on the server? It should have nothing to do with
>my computer, right? I got very confused. Any help will be greatly
>appreciated.
>Cindy
>