If it's a standard source/destination Dataflow, then no, it does not cache.

Maybe your package is a little more complex than that and there is something in the logic that is...

Yes.

This is hard to visualise without some sample data. I am picturing a single resultset easily enough - but the splitting into different tables bit is less easy.

If there are...

If you use a different delimiter, does it work OK?

Your hypothesis that SSIS is not generating delimiters in certain circumstances fails to explain why the columns would ever "shift...

Something's changed - you're just not sure what it is!

You could try using RegSvr32 to register these DLLs:

C:\WINNT\System32\Msjetoledb40.dll

C:\WINNT\System32\Msjet40.dll

C:\WINNT\System32\Mswstr10.dll

C:\WINNT\System32\Msjter40.dll

C:\WINNT\System32\Msjint40.dll

Wow, your post puzzled me for a while. I think you meant 'source folder', not 'destination folder', also 'importing' rather than 'exporting', as you are putting data into SQL Server,...

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