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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!