Home > IT Answers > SQL Server > Bulk Insert VS DTS
Manickam
0 pts.
 Bulk Insert VS DTS
SQL Server
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

Software/Hardware used:
ASKED: June 1, 2006  10:09 AM
UPDATED: June 1, 2006  11:17 AM
RELATED QUESTIONS
Answer Wiki:
I think that the only way to do this would be to map your terminal to a drive and use the drive designation in bcp. I don't think bcp recognizes UNCs.
Last Wiki Answer Submitted:  June 1, 2006  10:27 am  by  PurpleLady   0 pts.
All Answer Wiki Contributors:  PurpleLady   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Another possibility would be to install SQL Client Tools on your computer so that you would have the bcp utility available on your terminal. I’m pretty sure that bcp comes packaged in SQL Client Tools. If it’s not in there, then you could probably get it from installing SQL Server 2000 MSDE.

Stephen09
 15 pts.