Issue:

For some reason, unknown to many in the google-verse, trying to deploy the ipsac file using SSMS 17 causes there to be a version discrepancy with the script tasks (e.g. – “version 15 is not supported in this version of SSIS, etc.).  Two primary options are deploying directly from Visual Studio (I used VS 2017) OR deploying using SSMS 16.5.

Resolution:

Use SSMS 16 instead of SSMS 17 to deploy IPSAC SSIS package.

Sources:

https://social.msdn.microsoft.com/Forums/en-US/8c45962d-ac7b-4e2c-a4f6-c93479b57908/differnece-between-ispac-and-ssdt-deploy?forum=sqlintegrationservices

Last modified: September 23, 2021

Author

Comments

Write a Reply or Comment