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
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
0 comments
Accepted answer
  1. Monalv-MSFT 5,891 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
Most helpful Newest Oldest