We work alot with mysql and will only be doing more, although sql server will remain prevalent. We utilize SSIS, and even DTS still, to move our data around. Problem is working with mysql in SSIS 2005 is a pain and now I've run into a situation where it might take a bunch of hacks. So I read that 2012 will take care of a few issues I'm having. Mainly actual ODBC sources and destinations, and no 4000 character expression limit.
We have several sql server 2005 instances running already. I see that a sql server development license is really cheap. So I have two questions. If I were to purchase a 2012 sql server developer license...
1. Would the license allow me to develop 2012 version packages and deploy them to a 2005 instance?
2. Would a 2012 package run using 2005 sql server? I plan on running the packages from the file system using sql agent.