In our virtual QA environment, which contains several SQL servers, I wanted to deploy the SSIS 2012 package (ispac, project deployment), supported through Visual Studio 2010. The target SSIS server was in 2012, but the client on the workstation included SQL Server 2014 By executing the ispac package on the workstation and indicating deployment to SQL Server 2012, the deployment completed without error. But when we run the package on the SSIS server, we get errors such as
Package Name: Error: The version number in the package is not valid. The version number cannot be greater than the current version
number.
"Package Name": Error: Error loading value "8" from node. "DTS: Property"
“Package name”: error: migration of packages from version 8 to version 6 with error 0xC001700A “The version number in the package is invalid. The version number cannot be greater than the current version number.”.
In my package (.dtsx) there is
<DTS:Property DTS:Name="PackageFormatVersion">6</DTS:Property>
Like the manifest
<SSIS:Property SSIS:Name="PackageFormatVersion">6</SSIS:Property>
It looks like the SQL 2014 client or workstation upgraded my package to V8, although my target server was V6. When I deployed directly from SQL Server 2012 (which did not have SQL 2014), everything was deployed and executed as expected. Is this the expected result? or problem
source
share