sanjuv999 (9/25/2012)
please guide me
Do not enable xp_cmdshell! You do not need it for this scenario and it introduces risk in your environment.
If you want to do everyting with T-SQL use for this task BULK INSERT.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato