CODEWITHSUNDEEP
ftpssis
Raymond A
Raymond A

Reputation: 793

SSIS FTP Task - Downloading source files approach

Im to develop a SSIS package that have to download a list of files from a FTP location.Although the frequency and timings of retrieving the generated files have been agreed upon with the client .

I noticed many times that when connecting , the user files (CSV) are being created (size gradually increasing) and that those downloaded are partially complete in content. One suggestion i received was to have a "check file" a file which would be created and the end of the files creation by the client which would inform me that the file are ready to be downloaded,should it not be found no download shall happen.

However, i would like to know if other options are available ,which can be integrated in SSIS.

Thanks

Upvotes: 0

Views: 617

Answers (1)

Mike Honey
Mike Honey

Reputation: 15017

I would follow the 'check file' pattern. I would not introduce a new communications mode (e.g. email) which implies further complexity and configuration.

Lately for FTP tasks I have been calling WinSCP rather than using the SSIS FTP Task. It has better functionality. Here's their info on this topic:

http://winscp.net/eng/docs/script_checking_file_existence

Upvotes: 2

Related Questions