--sorry, misread post & answered incorrectly

Sounds like it would work ... if running...

?

You need to move everything apart from the latest file first - manually - before running the package.

From then on, assuming that you run this every day, all will be...

Use a File System 'Move File' task.

divyanth (3/30/2010)

---

🙂 I agree with you on that Phill, I was just trying to help him with the code...

david.morrison-1035652 (3/30/2010)

---

you need to put double backslashes in all paths I've found as ssis treats a single backslash as an escape character, you double them up to aviod this.

Phil, I...

Wrong. File names and folder names cannot contain slashes.

david.morrison-1035652 (3/30/2010)

---

Phil Parkin (3/30/2010)

---

There is another option which does not require script. Put the whole process inside a FOREACH container. When the package executes, if the FOREACH container does not...

Folder names cannot contain slashes. Try replacing slash with - and you should have more luck.

The two backslashes are causing the error. Surely just a single \ is all that you need?

There is another option which does not require script. Put the whole process inside a FOREACH container. When the package executes, if the FOREACH container does not find a matching...

david.morrison-1035652 (3/30/2010)

---

Phil Parkin (3/30/2010)

---

I do not believe that this is the most efficient way of working.

I get the impression that most people here move files to an archive folder once...

I do not believe that this is the most efficient way of working.

I get the impression that most people here move files to an archive folder once they have been...

Please post the text of your error message.

OK - you're using a space as a field delimiter. A bit risky unless you are sure that your data cannot contain even a single space.

So you need to check...