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.
Comments