Jeff Moden (8/27/2013)

---

Koen Verbeeck (8/26/2013)

---

rocky_498 (8/26/2013)

---

Thanks, that was I was thinking....

I am thinking how about If I get Recent file name from folder?

Is anyone can please guide me how i can recent file name from folder in SSIS?

Thank You,

You want the most recent file from the folder?

You'll probably want to do this with a script task, using some .net code.

http://stackoverflow.com/questions/1179970/c-sharp-find-most-recent-file-in-dir

Heh... isn't that nice... someone took the time to create the DOS DIR command with a /o-d switch in C#. 😉 I don't know much about SSIS but why can't you use something like a CmdExec task and take the top 1 from that return?