How to import package from SSISDB catalog with server authentication to visual studio

hosein alirezabeigi 21 Reputation points
2023-08-05T06:56:26.1233333+00:00

Hello

I want to add a package from a server (not local) to a new project in visual studio using import wizard, one it wants my server name it can not connect to server. I think it is because an authentication is required but I can not give the authentication in server name section

Screenshot 2023-08-05 102410

ame section

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,675 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Amira Bedhiafi 31,391 Reputation points
    2023-08-05T13:58:53.0466667+00:00

    It seems like you're trying to add a package from a remote server to a new project in Visual Studio using the import wizard. However, you're experiencing difficulties because the tool isn't able to connect to the server. This could potentially be due to the requirement for authentication, which you are unable to provide in the server name section of the import wizard. This suggests that the process may not be designed to handle an authentication step, or that the authentication details need to be inputted somewhere else or in a different way. To overcome this, you may need to look for an alternative method to authenticate the connection, perhaps through the settings or configuration files. If this does not resolve the issue, there may be other factors at play, such as network issues or server configurations, which you might need to investigate further.

    0 comments No comments

  2. ZoeHui-MSFT 41,446 Reputation points
    2023-08-07T01:43:43.7033333+00:00

    Hi @hosein alirezabeigi

    If you choose browse, can you select the server?

    Could you provide more error message so that we could narrow down the issue.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.