You have to use an expression builder to create the file name and assign it to the CSV connection manager. Then you can assign the particular file name with date when it is created. See this link.. http://www.sqlnerd.com/ssis_dynamic_dates.htm