SSIS - return the name of the generated file RRS feed

  • Question

  • Hello,

    I have a SSIS package which exports a CSV file which has the date and hour of the generation included in its name. I need to use the generated file name in a send-mail task. How could I keep in a variable the name of the file?

    Thank you.

    Monday, October 21, 2019 12:38 PM

All replies

  • Hi Onaa,

    We could use Foreach Loop Container to get the filename from the CSV file to SSIS variable.

    Best Regards,


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Tuesday, October 22, 2019 1:39 AM