Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 FTP upload completion check

Author  Topic 

Hommer
Aged Yak Warrior

808 Posts

Posted - 2008-06-23 : 12:19:50
Hi, all,

I am looking for a way to programatically identify a file is completely uploaded to the ftp site, so the download/copy could start.

Currently, the process we have occassional run into the problem of downloading partial file becauseour partner has not finished uploading.

Thanks!

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2008-06-23 : 15:50:20
Hope this helps:

http://agilebi.com/cs/blogs/jwelch/archive/2008/05/13/see-if-a-file-is-locked.aspx
Go to Top of Page

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2008-06-23 : 16:41:00
So, if @[User::FileLocked]==false (OR constraint) then execute Data Flow Task.
Go to Top of Page

Hommer
Aged Yak Warrior

808 Posts

Posted - 2008-06-23 : 16:56:25
Great! That is certainly something what I can leverage off.
Go to Top of Page
   

- Advertisement -