Post reply

Retrying a failed ftp job

  • June 18, 2004 at 2:21 am

    #360153

    Hi all

    I've got a DTS package that uses the CreateProcess task to run ftp to fetch two fairly large database backup files (total size 13GB) from another server on the network.

    I've found that sometimes the FTP fails, however according to DTS, the step ran successfully.

    Is there any way to check from within DTS or as part of a sql agent job, for the existance of a file so that I could tell if I need to rerun the package containing the FTP

    The ftp will be replaced by SQL replication within 3 months, so I'm just looking for something (preferably simple) that will help in the meantime.

    Thanks for your help

    Gail

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 21, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • June 21, 2004 at 7:16 pm

    #511334

    Take a look at,

    http://www.sqldts.com/default.aspx?103

    Looping, Importing and Archiving

    How can I check if a file exists?

    --------------------
    Colt 45 - the original point and click interface

  • June 22, 2004 at 12:36 am

    #511341

    Looks perfect. Thanks for your help

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply