• Hi Varun,

    Thank U for your answer.

    But one difficulty that I have is to create the folder only if it doesn't exist.

    Do U know how to implement it with SSIS script task ??

    Because I need to:

    1- Export data from my database filtered by Region and Month (because of files that I want to export )

    I think that I will use a ForeachLoop Container with SSIS DFT task inside it.

    And have Region and Month in parameter for the filter clause

    2- Create a folder with Month Name only if it doesn't exist (use script task or File system task ???)

    3- Create a sub-folder with Region Name only if it doesn't exist (use script task or File system task ???)

    4- Export Files in subfolder that I create .

    Please can U help me to implement it ???