Creating a SSIS package. I need to write data in a flat file form one of my tables. So I created a flat file connection manager which has the file name and all the columns in the file. I added a data flow task to my package. On the data flow tab I added OLE DB Source connecting to a flat file destination.
I want to name my flat file same as the project name +".txt". The project name is stored in a user variable, but I don't see where I can specify that file naming convention. Please advice.