I am trying to load a text file into a temporary table in MS-SQL using DTS.

The file is coming from a unix machine and contains comma-delimited entries.

the DTS script runs every minute and the transformation maps values in the text file into corresponding columns in the temp table.

The problem is that the sequence of the entries in the text file does not match the sequence of the values imported.

I have several instances of this script (all identical) but only one file seems to be out of whack. Does anyone know what could be causing this? This is for a real-time trading system so the sequence has to be perfect.

Thanks
Alastair