DTS FTP & Scheduling

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Sal (Sal_Cifone_at_adp.com)
Date: 01/25/05 

Date: 25 Jan 2005 13:38:06 -0800

Hello All,

I created a simple DTS package which uses the FTP task in Enterprise
Manager. I want to get a file off of the SQL Server D:\ Drive and copy
it to a network server , the F:\ Drive.

When I manually execute the job (right click execute package) it runs
perfectly. When I try to schedule it it fails giving me the error of:
=============================================================

Executed as user: PAR2MAGELLAN\SYSTEM. ..... DTSRun OnStart:
DTSStep_DTSExecutePackageTask_1 DTSRun OnProgress:
DTSStep_DTSExecutePackageTask_1; DTSStep_DTSFTPTask_1: Copying file to
F:\SHARED\FRS_Extract\SBS_FPRA_Export.txt.; PercentComplete = 0;
ProgressCount = 1 DTSRun OnError: DTSStep_DTSExecutePackageTask_1,
Error = -2147220493 (800403F3) Error string:
DTSStep_DTSFTPTask_1: Can not transfer file
D:\hyperion\essbase\App\SBSFRS\SBSFRS\SBS_FPRA_Export.txt from the
source directory to the destination directory. Please make sure the
directories exist and you have sufficient rights to access them.
Error source: File Transfer Protocol Task Help file: Help
context: 0 Error Detail Records: Error: 0 (0); Provider
Error: 0 (0) Error string: Can not transfer file
D:\hyperion\essbase\App\SBSFRS\SBSFRS\SBS_FPRA_Export.txt from the
source directory to the destination directory. Please make sure the
directories exist and you have sufficient righ. The step succeeded.
===========================================================
I am confused, can someone help,

Thanks,
Sal

Relevant Pages

  • DTSRUN privileges?
    ... I am trying to get a DTS package to be run from the command line with the dtsrun utility. ... The user I supply is a user in the database. ... It looks to me like the SQL Server instance does exist because it tries to start the package. ...
    (comp.databases.ms-sqlserver)
  • Is there a way to execute a DTS package for SQL Server through OLEDB
    ... Hi I am tryin to figure out if it is possible to execute a DTS package( ... either file or stored within the SQL server itself) using OLEDB. ... DTSPackageDSO provider but am unsure how to use it. ...
    (microsoft.public.data.oledb)
  • Is there a way to execute a DTS package for SQL Server through OLEDB
    ... Hi I am tryin to figure out if it is possible to execute a DTS package( ... either file or stored within the SQL server itself) using OLEDB. ... DTSPackageDSO provider but am unsure how to use it. ...
    (microsoft.public.sqlserver.programming)
  • DTS export data from Sqlserver to MDB
    ... I setup a DTS package to export a table from sql server to microsoft acess ... Z:\Payment ... I can execute the DTS package from Enterprise Manager but I want to allow my ...
    (microsoft.public.sqlserver.dts)
  • Re: Job in a package
    ... called from an SQL Execute task of DTS packages. ... Vyas, MVP (SQL Server) ... I'm looking for a solution for my Intranet users to execute ... Is it possible to execute a job in a DTS package? ...
    (microsoft.public.sqlserver.dts)