Hi all,

i tested in all ways.I'm able to insert bibdata table in dts perfectly but i need to insert abdata using dts.i want only one way either dts or bcp and whenever text file(bibdata and abdata) comes to ftpserver it should automatically download and insert into the database(scheduler).everyday data loads in text files in ftpserver.that automatically insert into the db.what i've to do for that.i've to write a vb component for that.can any tell me hw i've to proceed.i don't know that much vb,

thanks
venkat