Good point about using a UDF. With regard to using BCP, my original requirement used files which didn't have a consistent number of fields on each line e.g.: -

1,2

1,2,3

1

etc...

I couldn't get BCP / Bulk insert to work with these types of files, so that was the reason behind using DTS.

Thanks for the reply.

Regards,

Andy Jones