Re: DTS package from scheduled job fails

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 02/26/05 

Date: Sat, 26 Feb 2005 12:13:26 +0000

The problem more than likely lies in the fact that the user account
under which you execute the job has no idea about the mapped drive.
This is why it is a good idea to use UNC paths to reference files.

http://support.microsoft.com/?kbid=269074

Allan

"Christian Risager" <Christian Risager@discussions.microsoft.com> wrote
in message news:Christian Risager@discussions.microsoft.com:
> Hi there.
> I have implementet a koncept in SQLserver to import data
> from an Access-database using DTS-package. There is no
> problem starting the package from SQLserver Enterprise
> mangager.
> However, I want to execute the package from a third party
> sql-interface, and therefore I made at scheduled job that
> execute the package. No problem if the access database is
> located on the same server as SQLserver Enterprise manager.
> But if I place the Access-database on another server, map
> the networkdrive from the SQLserver-server, the scheduled
> job fails with an error: "...not a valid path...".
> And I can still execute the package from within Enterprise
> Manager without problems.
> I have tried to change the owner of the job to variuos
> users and administrators, but without any success.
> I use this syntaks from a SQL-interface to start the job:
> use msdb;EXEC sp_start_job @job_name
> = 'fasdata_import';use <gis-database name>
>
> 1. Can I execute the package directly from an SQL-
> interface?
> 2. If not - how do I overcome this error with the job
> executing the package.
>
> Best regards
>
> Christian

Relevant Pages

  • Nested packages not firing events when executed via .NET interop
    ... This works fine on individual packages, but when I execute a package ... void PackageEvents.OnError(string EventSource, int ErrorCode, ...
    (microsoft.public.sqlserver.dts)
  • Re: Using Python in ActiveX task - works when run as separate step
    ... when executing the package. ... Peter Yang, if you can detail some of what you did to get Perl working, I'd ... >> was trying to use Python in this case because I know it a little better than ... >>>You could execute the step in DTS package window. ...
    (microsoft.public.sqlserver.dts)
  • Re: alter index (Oracle Text index) rebuild on different schema => no rights
    ... I put the "alter index" statement in a stored procedure and put it in ... The execution of the package has to ... Execute it dynamically as a workaround. ... REBUILD statement without proper PARAMETERS clause (which ...
    (comp.databases.oracle.misc)
  • Not all steps in DTS package execute
    ... When run through DTS Designer, all steps execute except the last one (Step ... DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2 ... Microsoft Data Transformation Services Package ...
    (microsoft.public.sqlserver.dts)
  • Re: Package: symbol reading woes
    ... package hasn't been loaded at read time." ... Maybe I'll need to settle for eval? ... it looks to me (I didn't execute your code and don't ... maybe you can just load the library. ...
    (comp.lang.lisp)