August 24, 2011 at 5:41 am
Hi,
i am running a BCP from SSMS, when i ran the BCP Going to that perticular server(taking remote) all goes well but when i run it from my local machine it fails giving error.
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
Declare @bcpCommand varchar(2000)
SET @bcpCommand = 'bcp dbarea.dbo.tempdelete in "\\XXXX\CVSProject\ExtraCare\EC_20110801.csv" -c -SXXXXX -t, -T'
EXEC master..xp_cmdshell @bcpCommand
August 24, 2011 at 6:46 am
Just to add on above issue, i am not able to run the below as well
"EXEC master..xp_cmdshell 'DIR'" from my machine.
any suggestions??
August 24, 2011 at 7:00 am
Just to add on above issue, i am not able to run the below as well
"EXEC master..xp_cmdshell 'DIR'" from my machine.
any suggestions??
August 24, 2011 at 7:33 am
I got the answer, IT team has intalled IPS on each location which is blocking SP_CMDSHELL to execute at other location to avoid SQL Injection.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply