Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Blessed1978
Yak Posting Veteran
97 Posts |
 Posted - 2014-09-05 : 13:54:25
|
| I created a IS package that is suppose to go to out ftp site and pick up files. I am currently hard coding the dates i need in the FTP TASK for specific files, for example if i need all august files i would use drfiles201408*. I would like to get away from hardcoding the files or using wild cards and write a script task or variable within the FTP TASK to pick up files based on the month. so if my process runs in sept it should pick up sept files not august or october. All files on the FTP stite are date stamped example drfiles20140809 or drfiles20140909 thats how i would know the date of the files. does anyone know how to dynamically created this IS packages without hard coding the dates |
|
|
|
|
|
SSIS FTP TASK HELP