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 ???