Menu
I have a package that is developed in SSIS 2012 using Visual Studio 2010.
Is it possible to deploy/attach this package on SQL Server 2008
If it is possible, does the licence of the sql server matter
916
no, you cant. SSIS package are not backwards compatible. Also it doesn't make much sense if you think about it. If it was the other way around, "maybe" it could be done because 2012 would somehow be aware of 2008 structure, but 2008 engine isn't aware of 2012 package structure.
On the Solution Explorer of the BIDS environment, right click on the Project Node and select the Properties. Set the “CreateDeploymentUtility” to true and click OK. Right click on the Project node and click Build, which will generate Integration Service Deployment manifest file under the Project/Bin/Deployment folder.
Integration Services supports two deployment models, the project deployment model and the legacy package deployment model.
a) File system deployment:Go to manifest file → rt click → deploy → next → select file system deployment → specify folder to deploy → click next → next → finish. Go to deployed folder and observe the package and configuration files deployed or not.
no, you cant. SSIS package are not backwards compatible.
Also it doesn't make much sense if you think about it. If it was the other way around, "maybe" it could be done because 2012 would somehow be aware of 2008 structure, but 2008 engine isn't aware of 2012 package structure.
143
You cannot run it with the 2008 version of dtexec and you certainly cannot deploy it into the catalog, but if you could install the minimum you need to run SSIS 2012 onto a server somewhere you could then execute the package from filesystem with the 2012 version of dtexec.
See also http://msdn.microsoft.com/en-us/library/bb522577.aspx
36
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
