SSIS - output to excel with filename with date

nononame2021 256 Reputation points
2022-06-15T09:55:35.587+00:00

how can i output a filename with date format yyyymmdd
filename_yyyymmdd.xlsx format by SSIS

does it setup by variable ? any sample?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,628 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Yitzhak Khabinsky 26,296 Reputation points
    2022-06-15T13:20:11.967+00:00

    Hi @nononame2021 ,

    Here is a good article on the subject: dynamic-file-name-for-excel-connection-manager-ssis

    2 people found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.