Script task - check timestamp of remote ftp files
This is probably a simply question, but I cannot find any posts out there that helps. I need the vb.net code to check the time stamp of the remote ftp files (comparing with current month of system time) before downloading. Any help would be great!Mitch Cheung
April 25th, 2011 10:27am

I think the easiest is to access the FTP site and dump its DIR command output to a file. You can then parse this file using VB to determine the age. I was able to find this post that uses a VBScript to do the same, please take a look: http://social.technet.microsoft.com/Forums/en-US/ITCG/thread/c352c9aa-fad2-4076-a605-55ef44c09aafArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
April 25th, 2011 10:35am

Can someone show me how to invoke the 'dir' command on the remote ftp server and grab its result set by using the FtpClientConnection object or other object(s) within a SSIS script task? Many Thanks.Mitch Cheung
May 11th, 2011 9:45am

I have just found you a MSDN Forum post where you can get the code you need from: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/b775c23c-29a8-436a-9d28-a338b35a5c3a/ Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2011 9:53am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics