I have developed a SSIS package using VS 2012 and i have deployed the same package successfully in another server which has SQL server 2012, but this server has VS 2010 installed, Now i am getting error when executing the deployed package using script in that server.
My friend told me that, this issue is due to the VS version difference between development machine(VS 2012) and deployment server(VS 2012).
please let me know whether my deployment server also need upgrade to VS 2012 for executing my package?
Way of Execution :
I am executing the package from SSMS, "Right click the deployed package - > Execute"
Actual Error Messages :
The package failed to load due to error 0XC0010014 “One or more error occurred There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors” This occurs when CPackage::LoadFromXML fails
Package:Error Package migration from version 8 to version 6 failed with error 0XC001700A “The version number in the package is not valid. The version number cannot be greater than current version number”
Package:Error The version number in the package is not valid The version number cannot be greater than current version number
Purpose of the package :
This is a sample package for the deployment testing, i have used a single transformation for source to destination transfer.
