Hi All, Is there any backward compatibilty components for SSIS 2008 available with 2012? . We need to make use of SSIS 2008 in a machine that has SQL server 2012 installed.

You mean you want to run packages created in SSIS 2008 with SQL Server 2012?MCTS, MCITP - Please mark posts as answered where appropriate.

Hi Koen Verbeeck, No , we need to run the application that was built against SSIS 2008 in SQL server 2012 . The application was developed using SSIS 2008 object model with SSIS 2008 dlls referred to it.

Hi Koen Verbeeck, No , we need to run the application that was built against SSIS 2008 in SQL server 2012 . The application was developed using SSIS 2008 object model with SSIS 2008 dlls referred to it. You build ssis 2008 custom components that you want to convert to ssis 2012. 1) You have to change the references from 2008 to 2012 2) optional change the target framework to 4 3) change all objects with 100 in the name to 110 Enumarators are easy to convert, task and transformations are more work... same for windows applications that call ssis functionality. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Thanks for your suggestion. Is there any alternative way that we can install SSIS 2008 components and make use of those reference? like DTS providing backward compatibility . Our concern is that creating two different installers for our application targetting SSIS 2008 and 2012 wont be a generic solution.

The only other alternative is to install SSIS 2008 on those machines. (You don't need to install a database instance, just the shared services of SSIS 2008.) Talk to me now on

Thanks Todd.

Todd, Can you make use of SSIS catalog running SSIS 2008 packages on SQL 2012 server? Or do only upgraded packages deploy to catalog? TIA, Josh

I'm a little confused by your question and which bits and versions you're referring to. Can you restate your question? Talk to me now on

Can SSIS 2008 packages be added to the new catalog or do they have to be migrated to 2012 project deployment method in order to use catalog features like logging and execution, etc.? Related question...Can 2008 packages be migrated and executed from catalog without changing variables into parameters? In other words, can the change from variables to parameters be done later, meanwhile migrated packages are able to run in the new catalog using variables?

You need to migrate them to the new 2012 project deployment model. I'm not sure if variables are upgraded to parameters per se. Maybe if the take part in an expression. MCTS, MCITP - Please mark posts as answered where appropriate.