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?
This is driving me nuts...
I have nailed it down to the following, but I don't know why it's happening or how to stop it.
IIS worker process which is handling a web service is creating multiple copies of the same DLL, and a PDB, and an empty .tmp file every minute or two in my WINDOWS/Temp directory. I know it's the worker process for the web service which is doing it, because when I try to delete the files, it won't let me, and ProcExp says that the IIS worker process has the file, then digging into that worker process, I can tell it's the one running my web service. It is creating files like this...
tmp2A95.tmp.pdb
tmp2A95.tmp
tmp2A95.tmp.dll
Always in sets of these three files, but with sequential hex numbering skipping by three... so the next group of files would be tmp2A98
These are being created at a rate of about... well... 12,000 files over the weekend. It fills up my hard drive and starts to cause problems on the web site.
This is vendor software, and they have no idea why this is happening, and I've done my best to track it down, but I don't have access to their source code. They keep having me do ridiculous things that have nothing to do with the problem, and we haven't been able to fix it for about 6 months.
There are no errors in the event log, nothing in the IIS logs, and the DLL is a copy of one of their API libraries. The weird thing is the PDB... there's no other PDB files on the entire server - these are being generated directly from the DLL itself?
Please let me know if you've seen this kind of thing before, or if you know what causes IIS to drop a trio of files like that in the temp folder.
Thanks!