I had an issue this morning whereby I was trying to deploy an SSIS 2008 project using the Deployment Manifest, and was hitting the following error:
Could not save the package “<Package Path>” to SQL Server “<SQL Server>”.——————————
A quick Google search indicated that the issue was to do with a SQL Server 2005 installation that had been upgraded to 2008. Right-clicking the Deployment Manifest file showed two options for the Installation Package Utility. Even though both said 2005, one was actually pointing to the 2008 version. Choosing this one corrected the problem. The default location for the 2008 version is
C:Program FilesMicrosoft SQL Server100DTSBinndtsinstall.exe
You can also run this via the command line:
C:Program FilesMicrosoft SQL Server100DTSBinndtsinstall.exe "C:<project path>ProjectName.SSISDeploymentManifest"