"Allan Mitchell" wrote:

> Hello rb,
>
> The package does not automatically have to fail. You could handle the "No
> File" through the "On Failure" precedence constraint. You could also set
> up the package to allow n errors before failing.
>
> To rename the file I would be tempted to use the File System task from the
> toolbox.
>
>
> allan
>
> > Hi Chris,
> >
> >> connect to ftp server
> >> check if file exists (the name is always the same)
> > Within DTS there is a FTP task where you can select a source,
> > destination, login information, etc. If the file does not exists this
> > task will fail, so automatically stopping the rest of your DTS
> > package.
> >
> >> rename file from test to test.txt
> >>
> > Once the FTP task has completed successfully you could have use an
> > ActiveX task to rename the file using the FileSystemObject model or
> > write a batch/cmd file to do the renaming and execute it with a
> > Execute Process Task.
> >
> > "Chris" wrote:
> >
> >> Hi,
> >> I need to download a file from an ftp server via my dts package. The
> >> order is
> >> connect to ftp server
> >> check if file exists (the name is always the same)
> >> if yes, down load file and delete copy on ftp server
> >> rename file from test to test.txt
> >> parse file (This I got working)
> >> I need help with the ftp part.
> >>
> >> Thanks
> >>
>
>