Have you tried using the Send Mail task?

SQLStatementSource, I think.

Use an Expression within an Execute SQL task to combine static text and variables for your UPDATE statement.

As long as you can find some suitable selection logic, you could use a conditional split to redirect header rows (to nowhere).

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