Post reply

FTP doesn't work with variable

  • February 5, 2015 at 9:03 am

    #303995

    Hi,

    I have a simple package with an FTP container.

    The FTP will send a file if I create a new connection manger with that exact file. Works and sends fine.

    But..

    I need to use a wildcard because the text file I am sending is created using a date. (20150205.txt)

    So I go into the FTP container and I tell it to create a new variable. I create the variable with data type string and a value of C:\folder\folder\*.txt. I then run just the FTP and it fails.

    Can't figure out how to get the FTP container to pickup my wildcard txt file.

    The exact error is "Unable to send files using FTP connection manager"

  • February 20, 2015 at 1:56 am

    #1778883

    We cannot use any wild cards in file name while sending it using FTP.

    Rather while creating this file, store the file name in an SSIS variable and use that variable as file name in FTP.

    Or if you cannot fetch this file name. Then

    Create a For each Loop container. Loop thru the folder location and fetch your file name using '*.txt'. Store it in a variable and use that variable as filename in FTP.

    ____________________________________________________________

    AP

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

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