(from memory) In your dataflow, just right-click on the line from your datasource and select Add DataReader.

Then follow the prompts to add the columns you are interested in.

Then when you...

If you add some data readers in your data flow just after your source, you should be able to easily verify whether the modified data is being read.

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.