SSIS-Failed for compatibility check with the package deloyment model

子涵 罗 21 Reputation points
2021-04-06T03:34:09.813+00:00

Hello everyone,

I've practiced SSIS with Microsoft tutorial and I'm stuck at Enable package configurations (https://learn.microsoft.com/zh-cn/sql/integration-services/lesson-5-2-enabling-and-configuring-package-configurations?view=sql-server-ver15) .

Please check the following picture for the problem:
84639-convet-to-package-deployment-model.png

Can anyone help me deal with this issue please? Thank you in advance!

SQL Server Integration Services
0 comments No comments
{count} votes

Answer accepted by question author
  1. Monalv-MSFT 5,926 Reputation points
    2021-04-06T06:50:32.37+00:00

    Hi @子涵 罗 ,

    According to your picture, there is a project connection manager in your SSIS package.

    Please convert the project connection manager to package connection manager.

    Please refer to the following link and pictures:
    Package level and project level connection managers
    84756-converttopackagedeploymentmodel.png
    84707-converttopackageconnectionmanager.png

    Best regards,
    Mona

    ----------

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 additional answers

Sort by: Most helpful

Your answer

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