FTP Task not completing during DTS job

[jrsansom]

Morning,

I have a DTS job that appears to be failing on an FTP transfer task (see below). It is one of two DTS jobs that run overnight, both of which download files from an FTP site. The smaller DTS job/File(2MB) completes sucessfully however tha larger(32MB) does not.

I suppose the two jobs could be in contention with one another however there should be more than adequate resource across the network. Both jobs have also been completing without fail for several months prior to this time.

Is there a default connection timeout on an FTP DTS Task?

Any suggestion would be most welcome.

Many Thanks,
John

Executed as user: CBIPROD01\SYSTEM. DTSRun:  Loading...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSActiveScriptTask_1   DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_1   DTSRun OnStart:  DTSStep_DTSFTPTask_1   DTSRun OnError:  DTSStep_DTSFTPTask_1, Error = -2147220488 (800403F8)      Error string:  One or more files could not be transferred.      Error source:  File Transfer Protocol Task      Help file:        Help context:  0      Error Detail Records:      Error:  0 (0); Provider Error:  0 (0)      Error string:  One or more files could not be transferred.      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.

 

[mutley1]

John,

Have you turned on package logging in the DTS package itself - the output files give a lot more info into error messages etc.

Usual 2 problems are:

1. Permissions - has anyone changed the permissions on the ftp location?
2. Timeout issues - I know you say it has been running for ages and is now suddenly failing, but if it is a file that is growing and growing, there is a possibility that the timeout limit has been reached

Another favourite is if there is any network issues during the evening (scheduled network maintenance might be interrupting? The good old network boys eh?! LOL

Rgds,

M.

 

[jrsansom]

Hi M,

Thank you for the reply.

1.We can rule out the FTP permissions.
2.Timeout is a possibility. Where can this be set/defined?

Below is the log output as requested.

The execution of the following DTS Package succeeded: 

Package Name: TPS_Download_And_Deploy
Package Description: (null)
Package ID: {3CDC75A7-C8AD-4D3C-877F-D87063B6A9A9}
Package Version: {E1F78720-1A11-4CB6-896D-BEE97C120D4B}
Package Execution Lineage: {AFB17631-8492-4EE8-A66C-F69FC806AA04}
Executed On: CBIPROD01
Executed By: SYSTEM
Execution Started: 8/24/2006 12:00:14 AM
Execution Completed: 8/24/2006 12:00:30 AM
Total Execution Time: 15.281 seconds

Package Steps execution information:


Step 'DTSStep_DTSActiveScriptTask_1' succeeded
Step Execution Started: 8/24/2006 12:00:15 AM
Step Execution Completed: 8/24/2006 12:00:16 AM
Total Step Execution Time: 1.219 seconds
Progress count in Step: 0

Step 'DTSStep_DTSFTPTask_1' failed

Step Error Source: File Transfer Protocol Task
Step Error Description:One or more files could not be transferred.
Step Error code: 800403F8
Step Error Help File:
Step Error Help Context ID:0

Step Execution Started: 8/24/2006 12:00:16 AM
Step Execution Completed: 8/24/2006 12:00:30 AM
Total Step Execution Time: 13.5 seconds
Progress count in Step: 0
Task Log for this step:
-----Start Task Log-----

Can not transfer file TPS/tps_ns.zip to \\CBIPROD01\d$\CTPS_TPS_Download_Temp\tps_ns.zip: The connection with the server was reset


-----End Task Log-----


Step 'DTSStep_DTSExecuteSQLTask_1' was not executed

Step 'DTSStep_DTSDataPumpTask_1' was not executed

Step 'DTSStep_DTSExecuteSQLTask_2' was not executed
****************************************************************************************************

 

[mutley1]

Yeah, connection to the server was reset sounds like either a network issue during transfer or a timeout. Can you monitor the network over the transfer period to see if it does drop at all?

I was just checking with someone else......if your timeout is set to say 30 mins but your file takes 45, then you'll probably see a timeout. Apparently, the timeout is set on the ftp server so have a look at iis etc. Sorry I can't point you in the exact location - maybe one ot the super users here will be more precise, but there's some info for a start!

HTH,

M.