Is the ftp task good only for files in ssis? and not for folders?

[aldi]

Hello all,

A web hosting company is hosting our website. The site stores a few files in individual folders for each order placed on the site. For example:

If customer1 place an order and gets order number 1027
and customer2 place another order and gets order number 1035
then two folders are created.

for customer1 it creates the folder called: 1027 - customer1
and for customer2 the folder called: 1035 - customer2

I need to copy these folders from the ftp site of the web hosting company to be able to use the xml for the order.

I have an ftp task in ssis that connects to the remote directory, but it only let me select one file at a time.

ei: for customer1 it will let me download only if i use the following type of path: /1027 - customer1/order_1027.xml

but went i use /*.* or just *.* it doesn't work

but I need to download all the folders and work with them locally to extract the xml file from each folder.

Is the ftp task only used for files?

Or do I have to use a combination of the ftp task with another one?

Please help!!!

Thanks in advance,

aldi

 

[AK4]

I haven't done it myself but the ftp task doc says you can do this with a foreach file loop:

To send multiple files and access multiple local files and directories, you can also execute the FTP task multiple times by including the task in a Foreach Loop. The Foreach Loop can enumerate across files in a directory using the For Each File enumerator. For more information, see Foreach Loop Container.

The FTP task supports the ? and * wildcard characters in paths. This lets the task access multiple files. However, you can use wildcard characters only in the part of the path that specifies the file name. For example, C:\MyDirectory\*.txt is a valid path, but C:\*\MyText.txt is not.

http://msdn.microsoft.com/en-us/library/ms137656.aspx

Don

 

[aldi]

AK4, thanks for replying!!!

I wrote a vb script to do it, but I would definetely like to do it with BI.

I'm going to give it a try and post back later in the week.

Thanks a lot!!!

Aldi