Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
msbolton
Starting Member
12 Posts |
 Posted - 2003-04-14 : 06:27:23
|
| I have created a DTS package the first step of which is to FTP a number of files from a server. The package works fine when I execute it myself.However, when I schedule the job it fails on the first step, the FTP task, and produces the following message.DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSFTPTask_1 DTSRun OnError: DTSStep_DTSFTPTask_1, Error = -2147220489 (800403F7) Error string: Folder Y:\MarkBData\CaMIS output\Outpatient MDS\ does not exist or is not accesible on destination. Error source: File Transfer Protocol Task Help file: Help context: 0 Error Detail Records: Error: 0 (0); Provider Error: 0 (0) Error string: Folder Y:\MarkBData\CaMIS output\Outpatient MDS\ does not exist or is not accesible on destination. Error source: File Transfer Protocol Task Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSFTPTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.The folder that it refers to is on a network drive that I am mapped to. The two possible problems that I can think of is with either the drive mapping or access to the folder.If I cannot use the mapped drive in this way does anyone have an idea of the best way of directing the files to the area that I need to? Alternatively does anyone know how I can grant the appropriate access level to the SQL Agents so that it can write the files to the folder?Any ideas are much appreciated!Thanks,Mark |
|
|
sonmanvb
Starting Member
6 Posts |
Posted - 2003-04-17 : 17:35:07
|
| I was having a simular problem.I installed sp3 and it fixed it.Sonny |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-17 : 17:43:19
|
| I always FTP by creating a text file with the commands thenexec master..xp_cmdshell 'ftp ....'==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Problem with Scheduling of FTP DTS