Hi,
I completed my ETL work on Friday and left my computer locked. When I came on Monday I got the below error message
'Shared Memory Provider Error 233 No Process Is On The Other End Of The Pipe"
I got this message when I was trying to alter the ODBE connection in my SSIS package. I was able to run queries properly in my SQL server.
After much browsing..I realised that I had to restart my DB..when I disconnected and tried to connect , i got the same error message.
T resolve this issue, one has to open the configuration manager and restart the SQL SERVER instance...bingo..u have got rid of the error
I completed my ETL work on Friday and left my computer locked. When I came on Monday I got the below error message
'Shared Memory Provider Error 233 No Process Is On The Other End Of The Pipe"
I got this message when I was trying to alter the ODBE connection in my SSIS package. I was able to run queries properly in my SQL server.
After much browsing..I realised that I had to restart my DB..when I disconnected and tried to connect , i got the same error message.
T resolve this issue, one has to open the configuration manager and restart the SQL SERVER instance...bingo..u have got rid of the error
