Get Remote File list Using FTP's Connection Manager

[hemanth mpk]

Hi
We were trying to use SFTP task to get the list of remote file names.
We store these file in Object Variable. I want to check what exactly
is in this object. We iterated this object through a ForEach loop
container and use a script task that executes a MessageBox. This
message box is pointed to the variable collected in ForEachLoop
container.

Can you guide me how can I get the exact list of actual file names
present in the remote folder.

looks like that Object Variable is not storing the names but rather
just : "CozyRoc.SqlServer.SSIS.FtpClientConnection2+FileInfo"

My question is how can I get the exact names of this remote files in
Object variable

Thank you
Hemanth

[Ivan Peev]

Hi Hemanth,

You have to cast the object to IFileInfo interface. It is documented
here:

http://www.cozyroc.com/ssis/common-api#IFileInfo

All remote file information is available thru this interface. The full
file name is available in the FullName property.

[William Ross]

How might you configure a foreach filename container? Or is this only within a script task?

Thanks.

[Ivan Peev]

Hi Bill,

Why do you need the file name ? Please elaborate what you are trying to accomplish.

[William Ross]

Never mind the file name. How would I grab only files created in the last 15 days?

Thanks.

[Ivan Peev]

Hi Bill,

Try: Modifiedtime > Now.AddDays(-15) 

[William Ross]

Can you please provide an example C# script illustrating the use of IFtpClient to retrieve files created in the last 15 days?

Your one liners are useless and there are no examples on the web.

[Ivan Peev]

Bill,

Why do you need to write script? Just setup the Filter below and you get will get the list of files for the past 15 days. 

[William Ross]

The SFTP task does not have a Remote Filter and when I set the LocalFilter to Modifiedtime > Now.AddDays(-15) I get the message:

IdentifierElement: Could not find a field/property/variable with the name 'ModifiedTime".

?

[William Ross]

And by the way, why do I have to justify using one of your allegedly supported features? I want to experiment with the API. Do you not have a single C# example of using IFtpClient?

[Ivan Peev]

Bill,

If you are working with the remote server, ModifiedTime will work fine and yes, you do have RemoteFilter parameter. For the LocalFilter parameter you have to use the members in the FileInfo class. For LocalFilter try:

LastWriteTime > Now.AddDays(-15)

[Ivan Peev]

Bill,

We have plenty of script examples on the public script repository here. For IFtpClient use check here.

[Bill Ross]

Any in C# that use the API?

 

Thanks.

[Ivan Peev]

Bill,

We don't have examples in C# because C# is not supported in SSIS 2005. You can easily translate the code into C# . The languages are similar.

[William Ross]

Is the remotefilter supposed to follow any documented syntax?

How do I do a startswith test in the remotefilter? For example, maybe?:

name.startswith("m")||name.startwith("j")

?

Thanks.

[Ivan Peev]

Hi Bill,

The Filter parameter syntax is FLEE. This is also stated on the SFTP Task documentation page here.

[William Ross]

How do I reference the file name? I notice you have LastModified available. Where is the list of properties available? And the FLEE documentation doesn't show "AddDays" as a valid method.

[Ivan Peev]

Bill,

All available properties are also listed on the SFTP Task documentation page. AddDays is a method on the standard .NET DateTime structure.

[William Ross]

And what pray tell does the .net datetime class  have to do with FLEE?

On Friday, October 8, 2010 11:35:06 AM UTC-4, hemanth mpk wrote:

[Ivan Peev]

Bill,

FLEE is a Fast Lightweight Expression Evaluator and it is based on .NET . It has a lot to do with .NET and the available classes.

[William Ross]

Trying to use your product is a bit of a quest. One must be very determined. One must relentlessly pursue clear answers. I'm sure you don't understand why you are not more successful despite your obvious intelligence.

[tel...@gmail.com]

I am trying to use the FTPS connection to get the list of Remote Files. I need this list so that I can compare which files i have already processed. My SSIS package will run once every day and look for new files by comparing to a local DB table. 

How do I accomplish this? Please provide detailed examples as I have not been successful so far in getting this to work. 

I used the SFTP task, did the FTPS connection, set the Action= Get remote files list, and then put a Foreach Loop. But at the ForEach loop container, I am unable to iterate/parse the results that come back from the SFTP task. I am hoping that this result contains a list of FIleNames, but that doesn't seem to be the case.

[Ivan Peev]

Hi,

The result returned by the SFTP Task is array object which contains IFileInfo objects. We have posted multiple code examples on the documentation page here.