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...

It's surely obvious to you why this is happening. You are using the comma for two purposes.

Please confirm what you would like the output file to look like.