SQLTeam.com | Weblogs | Forums

Changing Export Filename to Variable used in Stored proc


#1

I have a SSIS package that gathers data from a database table and exports it to a text file. The data gathered is using date range variables. If the user entered start date of 01/01/2017 to end date 2/01/2017. I would like the file name to be
Data_01/01/2017_02/01/2017.txt


#2

SSIS 2012+ has parameters, You could pass them from a calling program. ?The parameters could be used to name the output file.