StoredProcInputParam Script Error after map runs
A network-related or instance-specific error occurred while establishing a connecto to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)
Where the issue lies in exactly how the map is running and where do we see the error.
But taking a guess, I would assume you have an “after map success” or “after map fail” task in that you perhaps have a SQL Task there. And on that task, it is trying to make a sql connection to a server that no longer exists.
or you have a script task that is doing the same, either way.
You’d have to check your map tasks and verify the servers on the task to make sure they can be connected to.
If you would like to submit an answer or comment, please sign in to the eOne portal.