question

16517982 avatar image
0 Votes"
16517982 asked Monalv-msft commented

SSIS-Failed for compatibility check with the package deloyment model

Hello everyone,

I've practiced SSIS with Microsoft tutorial and I'm stuck at Enable package configurations (https://docs.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
convet-to-package-deployment-model.png (166.2 KiB)
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft commented

Hi @16517982 ,

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.




converttopackagedeploymentmodel.png (27.0 KiB)
converttopackageconnectionmanager.png (13.5 KiB)
· 4
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

16517982 avatar image 16517982 ·

Hi Mona,

Thank you for your answer and time. I've followed your instruction. While, there is new issue: the foreach file enumerator is empty. Please check the following picture. Can I ask is this because I convert the connection?

84883-the-foreach-file-enumerator-is-empty.png



Again, do appreciated for your help.

Kind regards,
Zihan Luo

0 Votes 0 ·
the-foreach-file-enumerator-is-empty.png (54.4 KiB)
Monalv-msft avatar image Monalv-msft 16517982 ·

Hi Zihan,

1.May I know if you can convert to package deployment model successfully?
If yes, please remember to accept the answer that resolved your issue. This can be beneficial to other community members reading this thread.

2.While, there is new issue: the foreach file enumerator is empty.
Please check if you set the folder name and file name correctly and if the specified files exist in the folder.
Could you please open a new post for this new issue?

Best regards,
Mona

0 Votes 0 ·
16517982 avatar image 16517982 Monalv-msft ·

Sweets as, I will open a new post for the second issue. Thanks again, Mona. Cheers, Zihan

0 Votes 0 ·
Show more comments