October 8, 2013 at 1:33 pm
I want a guide(s) which tell me all the compatibility issues that can occur due to differences in environment. I want a handbook which mentions things like -
(fictional points below)
You cannot migrate a SSIS 2005 SP 3 package to SSIS 2005 SP10,
You cannot migrate a SSIS 2005 package to SSIS 2012, but 2008 is possible.
If your environment has 2 or more versions (no SPs) of SSIS installed, deployment of packages could be a problem.
etc...
Its so painful...I take so much time to make a big package and then it does not work in deployment. Do, I have to always create a test package in dev , deploy it to prod to check for compatibility issues and if all is okay, actually proceed to build a full package in dev ?
🙁
October 8, 2013 at 1:45 pm
Normally packages should be compatible between different versions of the same edition.
For example, it should not matter if the destination is SSIS 2005 sp1 or sp2.
However, SSIS is not backwards compatible. Packages created in newer versions of SSIS will never work on older versions of SSIS.
Packages created on older versions can run on newer versions, but have to be upgraded first.
If you try to run an older package, the upgrade will be done on the fly. If the upgrade fails (for example incompatible script task), then the execution fails.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply