Remote Server(DB) conn from local DB
-
I have created one Ssis pkg in my local DB.I am connecting to the the remote server by using C# code in this Ssis pkg.But some cases(machines) it's giving error(user-component failure).So i need to conn remote DB and i have to execute Stored procedure in that DB. Can anyone give me suggestions to conn remote DB from local DB(machine) or Anyone known about this error?
-
I have created one Ssis pkg in my local DB.I am connecting to the the remote server by using C# code in this Ssis pkg.But some cases(machines) it's giving error(user-component failure).So i need to conn remote DB and i have to execute Stored procedure in that DB. Can anyone give me suggestions to conn remote DB from local DB(machine) or Anyone known about this error?
ravi11038 wrote:
I have created one Ssis pkg in my local DB
You are using SSIS.
ravi11038 wrote:
I am connecting to the the remote server by using C# code in this Ssis pkg
And SSIS is using C# code. And the C# code is handling the connection.
ravi11038 wrote:
But some cases(machines) it's giving error(user-component failure).
So? The solution is obviously to figure out what the connection
ravi11038 wrote:
So i need to conn remote DB and i have to execute Stored procedure in that DB.
A stored procedure on a remote machine will not fix a connection problem to the remote machine. Now perhaps you want to create a stored procedure on the local machine and it will connect to the remote machine. But that is just moving the connection problem from one place to another and is unlikely to solve the problem if you do not figure out what is actually causing the connection failure.