Post reply

FTP task can upload 2 file simultaneously

  • November 27, 2007 at 3:36 am

    #122463

    Hi all,

    I got a folder where there are many files.

    Via SSIS FTP task I can upload a single on a variable or with a direct connect.

    There is some other way for upload 2 files with only 1 task without use an asp.net task script? Or I must use 2 FTP task one for file?

    Tnks Alen , Italy

  • November 27, 2007 at 7:21 am

    #754542

    Hi Alen,

    There are a couple options available before going the script task route.

    Wildcards: Can you match the two file names with wild cards, * for multicharacter and ? for single character?

    Foreach Loop: Perhaps the Foreach Item enumerator will work. Add one column to the Enumeration Data data grid. Put the file names in the Enumeration Data data grid. Create a variable to hold the filenames. Place the FTP Task in the Foreach Loop container and set the IsRemotePathVariable to true and set the variable to the one populated by the Foreach. The file name could also come from an XML file or SQL Server table, just change the Foreach enumerator type.

    Norman

    DTS Package Search

    http://www.dtspackagesearch.com/

  • November 27, 2007 at 7:37 am

    #754551

    Thanks for your answer...but I don't want use 2 time conection on http://FTP...so I solved using an ASP.NET script....but your tip of * and ? are an valid option....

    thanks Alen

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply