Hi all, I have a package that runs a query and then encrypts and exports a file. I have a process that dynamically creates a filename using a stored proc. How do I export my filename using a query in SSIS and then use that to overwrite the filename before I export using the SFTP task? I'm still fairly new to SSIS ;) Thanks!
Seeing as nobody answered my question, I feel that I will answer it so that people looking at this will know what to do... I accomplished this by using a execute sql task, concatenating parts of the filename that I stored in a table by using a stored proc, output this into the result set (click result set). I then used a file task to rename the file with my variable that was overwritten by the result set!