Hello Everyone, I have created package in SSIS 2008. I want my package to run in SSIS 2005. Is it possible tht my package will run in 2005?

Hello Everyone, I have created package in SSIS 2008. I want my package to run in SSIS 2005. Is it possible tht my package will run in 2005? No. Not a chance. Sorry, but there isn't much you can do, except recreating the package in BIDS 2005 or upgrading your server to 2008.MCTS, MCITP - Please mark posts as answered where appropriate.

You can not run higher version of SSIS at lower engine, for running SSIS 2008 package you need SSIS 2008 engine on system.http://www.rad.pasfu.com

I want to know 1 more thing I want to create my package in SSIS 2008. My Database tables are in SQL Server 2005. Is it possible that My SSIS 2008 Package will extract data from 2005 table?

Yes of course, you can connect to any database version as you want within SSIS 2008, also every other DB in oracle or mysql or every db which you have data provider to it.http://www.rad.pasfu.com

I want to know 1 more thing I want to create my package in SSIS 2008. My Database tables are in SQL Server 2005. Is it possible that My SSIS 2008 Package will extract data from 2005 table? That will be no problem. The OLE DB provider can go to the SQL Server 2005 database without any problems.MCTS, MCITP - Please mark posts as answered where appropriate.

I want to create my package in SSIS 2008. My Database tables are in SQL Server 2005 as well as in SQL Server 2008. If my Source Table is in SQL Server 2008 and destination table is in SQL Server 2005 will my package will run .

I want to create my package in SSIS 2008. My Database tables are in SQL Server 2005 as well as in SQL Server 2008. If my Source Table is in SQL Server 2008 and destination table is in SQL Server 2005 will my package will run . The databases don't matter. The OLE DB provider can work with various versions of SQL Server. It is the SSIS engine itself you need to be worried about. 2005 SSIS can't run 2008 and you need to upgrade 2005 packages before you can run them on 2008. edit: one remark: when creating SSIS packages in BIDS 2008, and you operate on SQL Server 2005 databases, you can only use TSQL valid for SQL 2005. So for example, you can't use the MERGE statement on 2005. MCTS, MCITP - Please mark posts as answered where appropriate.

With SSIS , source and destination can be any database, trust me any database from sql server to flat file , just you need some data providers for some of them, for sql server you don't need anything, you can fetch data from any version of sql server and fill it to any other version.http://www.rad.pasfu.com

Someone made a downgrade tool: http://ssisdowngrade.codeplex.com/ This project allows you to downgrade a SQL 2008 package to SQL 2005. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com