SQL Server - PROBLEMA CON DTS PROGRAMADO

tengo un dts programado a una hora x, este como primer paso lee unos dbf de una pc que no es local. lo mas curioso es que me bota error de la ruta esta solo cuando corre atumaticamente y cuando lo hago manualmente todo anda de maravillas. alguien ha tebnido algun problema similar???????? aki les mando el error

p.d. ya he probado usando unidades de red

The execution of the following DTS Package failed:

Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description:Package failed because Step 'DTSStep_DTSDataPumpTask_1' failed.
Error code: 80040428
\Error Help File:sqldts80.hlp
Error Help Context ID:700

Package Name: NUEVO MIGRACION
Package Description: (null)
Package ID: {2D40B447-E4AC-4A7E-8F02-34679C5836B7}
Package Version: {D13C9A19-5313-4A48-BA14-673498551D2E}
Package Execution Lineage: {82FE2A09-9902-4C2F-AE8B-98BBCDB8798A}
Executed On: DEPESAPC1-SERV
Executed By: SYSTEM
Execution Started: 1/12/2006 11:55:38 AM
Execution Completed: 1/12/2006 11:55:39 AM
Total Execution Time: 0.328 seconds

Package Steps execution information:

Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft JET Database Engine
Step Error Description:'\\depesapc7\F\phlis\DATA' 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

Step Execution Started: 1/12/2006 11:55:38 AM
Step Execution Completed: 1/12/2006 11:55:39 AM
Total Step Execution Time: 0.281 seconds
Progress count in Step: 0

Step 'DTSStep_DTSDataPumpTask_3' was not executed

Step 'DTSStep_DTSDataPumpTask_4' was not executed

Step 'DTSStep_DTSDataPumpTask_5' was not executed

Step 'DTSStep_DTSExecuteSQLTask_1' was not executed

Step 'DTSStep_DTSDataPumpTask_6' was not executed

Step 'DTSStep_DTSDataPumpTask_8' was not executed

Step 'DTSStep_DTSDataPumpTask_9' was not executed

Step 'DTSStep_DTSDataPumpTask_10' was not executed

Step 'DTSStep_DTSExecuteSQLTask_2' succeeded
Step Execution Started: 1/12/2006 11:55:38 AM
Step Execution Completed: 1/12/2006 11:55:38 AM
Total Step Execution Time: 0.047 seconds
Progress count in Step: 0

Step 'DTSStep_DTSDataPumpTask_11' was not executed
****************************************************************************************************

revisa que el SQL agent pueda acceder a \\depesapc7\F\phlis\DATA

Hola.

Estoy tratando de usar un DTS para poder cargar un archivo pero me manda este error. Tendras alguna solución, me estoy conectando a otro servidor y cuando lo corro manualmente el DTS en SQL Srv 2000 si corre bien pero en un SP en SQL 2005 no.

ALTER PROCEDURE sp_EjecutarDTS(@Paquete varchar(500) )
As
declare @Sql varchar(8000)

Set @Sql = 'dtexec /DTS ' + @Paquete
exec master.dbo.xp_cmdshell @Sql

Go


Gracias

--dtexec

Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
NULL
Started: 04:36:54 p.m.
Could not load package "dtsCargaNew" because of error 0x80070057.
Description: The path is not valid.
Parameter name: folder
Source: MsDtsSrvr
Started: 04:36:54 p.m.
Finished: 04:36:54 p.m.
Elapsed: 0.032 seconds
NULL