SSIS dynamic file names

Is there a walk through somewhere for creating a SSIS that does the following...

Connects to SQL Server and executes a Stored procedure to get data

Sends that data to MS Excel with a dynamic file name
i.e.  \\servername\sharedname\myFileName_yyyymmdddd.xls

I'm pretty sure that I'll have to do a data type transformation...
Who is Participating?
Kyle AbrahamsConnect With a Mentor Senior .Net DeveloperCommented:

You can use a variable with an expression.

Just a note:  I usually keep 2 variable names, one for the path itself (EG:  \\servername\sharedname\) and 1 for the filename.

Saves a lot of headaches when you have to write an additional file there tomorrow.
lrbristerAuthor Commented:
Perfect.  Thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.