i have to do some bulk insertions from an excel file which is located on my terminal to sql server table which resides on another server..
i used dts to transform it and it was working fine.
but its not being possible to do the same by using 'bulk insert' or 'bcp' method.
the problem is sql server is in another server and i accessing it from my terminal which is in network.
even if u execute xp_cmdshell it gives info regarding drives existing on the server rather than giving by mine terminal drive info.
is there any way to do it.. definetly it would be possible as i accomplished the same task by using dts..
thanks in advance