Deploying SSIS package from SQL 2008 in SQL 2005
Posted on 2011-05-04
Potentially silly question, so please no laughing :)
Up to now, I have only built DTS packages and have not ventured into the brave new world of SSIS. That is about to change.
My question is, if I build an SSIS package using SQL2008, can I deploy that package on SQL2005, or will the package be incompatible?
If the answer is, "yes, they are compatible, but...", then please outline for me what the pifalls are, such as features that would not be supported, or extra steps I would need to take to ensure that backward compatibility.