October 14, 2013 at 3:27 pm
Hi guys,
Here is my question, I have to archive every day file. I know I can use
File System Task to transfer file from one folder to other. Here is the problem
File Name always different, here is the e.g (FileName_getdate), so filename
always gonna same_Date when package runs. Is anyone can guide me...
Thanks in advance.
October 15, 2013 at 12:17 am
If you've processed a file with a dynamic name, you must already have the file name in a variable. Use that in the FST.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 15, 2013 at 12:42 am
As Phil has already answered, there is an option called as "IsSourceConnectionVariable", set this as true and assign the variable name as the one holding the file name.
Here is a good resource:
Raunak J
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply