Thanks Brett. I know the tools you suggested me, but I think they canít help me so much.
What I need to do is process the information. The scenario is: I have two dbs one exporting data, A, and the other, B, importing them, communication is not assured, and moreover, depending on the incoming data and data on B db, I should update records on B or insert them, so, I think, I canít use bcp or bulk insert.
I have been working with oracle and pl-sql has system defined functions and procedures to access files from stored functions or procedures. I have look for the equivalent functions/procedures on T-sql and I havenít found any information, donít they exist?
If they donít exist I want to know if I can program DTS task to read data from files and process them.