Post reply

FTP task error

  • October 12, 2009 at 2:44 pm

    #385562

    Hi

    I have created a package for the following requirement:

    Pull the order(text) files from the FTP server every 30 minutes.

    Process and Load the files to the database.

    Archive the order files.

    I have scheduled the package to run using SQL Server Agent.

    The package runs successfully when the file does exist in ftp server. However, the package fails when there is no files in the ftp server.

    How to configure FTP task to prevent this error?

    Any idea/suggestion/alternative/link would be great.

    Thanks

    Ganesh

  • October 13, 2009 at 1:43 pm

    #1065370

    I have batch file which is first step in my job.If the file exist it will go to next step which is running SSIS package if the file doesn`t exist the job quits with exit code.

  • October 13, 2009 at 2:29 pm

    #1065393

    could you give me the link for that please.

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

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