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_Exp ort.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_Exp ort.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

it's because when it's runnig as a scheduled job, it runs under that persons' permissions (that the SQL agent is running as)

check these 2 thigns:

1) make sure that user has perms
2) change to a UNC path instead of pushing to a F drive-- i assume you're talking about a mapped network drive (from your verbage)

or if you are really hard up, you could probably map the network drive programmatically using this:

exec xp_cmdshell 'net use f: \\happyserver\happyshare'

--
Message posted via http://www.sqlmonster.com

Thanks,

The user does have permission, I am the user with admin rights, and I
also went to the server itself which is is logged in as the company's
admin user id and created the schedule from there, in both cases it
errors.
Also I did map the drive as \\xxx\xxxx\xxxx and still nothing.

Like I said, it works except when scheduled.

Any other ideas???

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Sal
Do not map the drive... use UNC path like \\servername\folder\
JFB

"Sal Cifone" <sal_cifone (AT) adp (DOT) com> wrote

Thanks,
This is the results from the error log.


Error: 0 (0); Provider Error: 0 (0)

Error string: Can not transfer file
\\ipaddress(servername)\directory\file_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



DTSRun OnFinish: DTSStep_DTSFTPTask_1

DTSRun: Package execution complete.



What is odd, the source directory is the D:\ drive of the SQL Server and
it does not recognize it.

I also had the Lan adminshare the folders and verify that all the user
ID's have full control of the source and destination directories. But,
again nothing. MS has not given me any clues either.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Dont use ip address... only servername, make sure the sql agent account have
permission to write and read in that directory.
Here is a complete detail... http://support.microsoft.com/?kbid=269074
Rgds
JFB


"Sal Cifone" <sal_cifone (AT) adp (DOT) com> wrote