Just like the title says. All I need is the BCP program on my client computer. The BCP will be from a remote machine, so I don't want to install SQL Express or the management studio or any of that.
How can I do this?
Asked
Active
Viewed 2,143 times
2
-
Sorry Mark, I posted this on the wrong site. Thanks for the move :) – Jasmine Jan 31 '11 at 22:25
1 Answers
1
The only supported way is to install one of the SQL Server distribution packages (MSI). You are prevented by the terms of the license you agreed to to copy the bpc.exe file to another location (or, for the matter, any other file or 'crap' as you call them). If you don't like this situation, then feel free to build your own bulk utility executable and redistribute it as you like. The interface is called IRowsetFastload is is documented, good luck.
Remus Rusanu
- 8,253
- 1
- 19
- 22
-
One of the proposed solutions was exactly that, but bcp can do what we want, so we figured that would be easier than creating and maintaining a custom program just for this one task. – Jasmine Jan 31 '11 at 22:28