hi,
i have a text file which is to be
migrated into a table in Sql server 2005,

but i dont want it to be done by using the utilities
i want it done by a trigger/script/function/procedure.

example.
i have a Text file ex1.txt
i have a table in SQL server called ex1.txt

while executing a trigger/script/function/procedure
the data's in the text file is to transfered into the table.

please help me in this.