1

I have deployed 2 SSIS package on a server. both fetches data from an Azure SQL Server. Both Packages have one execute SQL task and one for each loop container. for package one, execute SQL task returns an object which has 2 columns and in case of package two, it returns an object which has 4 columns.

The problem is i am getting the error "unable to complete login process due to delay in opening server connection" for package 2 but not for package 1. Both packages are running fine from my local.

1 Answer 1

0

you could use script select @@SERVERNAME; to verify the server is local or not, for remote server, it sometimes has connection issue.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.