FTP Error

[jnavarro]

I am trying to download files from a ftp server using DTS. I was able to add the files and download the information manually, however when I schedule the dts to run at a schedule time I get an error:

DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 713. Process Exit Code 1. The step failed.

Any idea what can be causing this error when I scheduled the task?

 

[SQLDenis]

When you run it manually the package runs with your security credentials for the FTP server
You have to add the same credentials to the SQL Server Box/user in order for it to work when you schedule it

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[jnavarro]

How do you find out the credentials on the ftp server and set it up on the server?

 

[SQLDenis]

Ask the FTP admin
Also another thing mught be is that your SQL server can not 'see' the FTP server, the ports might be disabled by the firewall

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[chamilz]

Where do you save this downloaded file?
IF you are saving in the local drive you could define your directory path for Ex. C:\folder.

But, if you saving in another server i.e. mapped drive, then you should define the destination path like this: \\server\folder


look at the destination directory path.

 

[jnavarro]

I am using the URL for the destination of the files. I am able to run the FTP manually but when I scheduled the task it fails.

In order for me to check if the security had something to do with this, I created a bat file on the server and schedule the task to run the files located on the FTP server. The bat file ran with no problems.
Any idea what is causing this?