I have a package that queries an OLE DB source and creates a CSV file to a folder using a dynamic name like so:
@[User::Dynamic_Filename] + (DT_STR,4,1252) DatePart("yyyy",getdate()) + Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) + Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2) + ".csv"
Basically, in the flat file connection I created the connection using the code above so that the file is dynamically named with a specified name and the current date.
It looks like there is no way I can send the extract csv straight to FTP . So I'm having to send it to a flat file source in a specified folder.
But it is this same file that I want to send to FTP i.e. with the dynamic date appendage. How can I create another variable to use for the local path so I use the file that was just dynamically created?