Thanks For the Respose

DTS is not an option. 

I can use BCP insert but it will insert data into all columns.  I don't see anyway to insert data for specific field...