copy a file daily automatically

Question

Hi,

one more clarification i need,

every day i'm getting file to server "//a/" i need to copy to server"//b/" which are in the same network of my client and file system task work to copy that file but how to catch every days new file by setting a date variable ? without doing manually?

Answer 1

You have already posted this question earlier..may be you can remove it

---

Nitesh Rai- Please mark the post as answered if it answers your question

Answer 2

hi maheshbabuk,

use expression for date in connection string of source.

---

Amit
Please mark as answer if helpful
http://fascinatingsql.wordpress.com/