ssis - how to generate excel attach the date to filename <<filename_yyyymmdd.xlsx>>

Question

how can i generate a excel file with date in filename (e.g. filename_yyyymmdd.xlsx)

or how to make the output expression by getdate() to yyyymmdd ?

any sample to reference.

Answer 1

Hi @nononame2021 ,

You may refer to 0395-sql-server-ssis-adding-date-and-time-to-a-file-name-after-processing.

It's detailed tutorial, you may follow it step by step.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @nononame2021 ,

You cannot directly change the file name with excel destination.

You need to use file system task to copy template file from template folder to destination folder and then change the file name.

Check ssis-tutorial-part-17-create-excel-file.html.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.