When i kill the process SQL goes into a roll back.

Does this mean that the rows inserted so far from the text file I am importing from will be removed leaving the destination table back in its original state?

Cheers for your help on this.

Eamon