I have a Integration Services project within SSDT that has multiple packages. When I right click a single package and choose deploy, SSDT says the operation completed successfully.
However, when I look at the
internal.packages table within SSISDB on the target server, it does not contain the latest version that I just deployed. Neither the
version_build field or the
version_guid field match the values within my package. The SSIS Catalog also displays the incorrect information.
It looks to me as though it is not deploying the package at all - except the
internal.projects table is clearly getting updated with a new time stamp on each deployment, and the
internal.packages table adds a new row as well.
So, my question is - why is the package not getting updated?