I've had unexpected problems with the File System task in the past. In the end, I threw in the towel and wrote a bit of script in a script task...

Jason Coleman (4/8/2010)

---

That is what I have described in the first post...

I can make the script so it searches for a particular file, but when the file (or files)...

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