I understand the basics of using the FTP task and data transformation with
..cvs files, but am looking for a more robust solution. I need to do the
following:
1. FTP ".cvs" files from a Unix box. The files reside in a cache directory
and any files that exist at the execution of the task must be ftp'd. The
names of the files are indeterminate.

2. The .cvs files from above all have the same format. I need to setup a
connection to the file retrieved from the above step and then perform simple
data transformation of mapping the file field for field into a SQL Server
table.

I understand how to do both steps when the name of the file is known.
Unfortunately the name of the files are unknown and accumulate on the Unix
box over the course of a day. Any help would be appreciated!

jeremy