Copy SSIS packages from 2005 to 2008


  • I have both vs 2005 and vs2008 on the same pc. When i try to copy the package from the BIDS 2008 from file Copy as i get an error

     Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported.

    Do you know how to fix this issue.
    Tuesday, September 21, 2010 6:41 PM


All replies

  • Hello Julliet,


    Backward compatibility is not supported as Error shows.


    Tuesday, September 21, 2010 6:45 PM
  • Is there any other way to do this package between sql 2008 and sql server 2005
    Wednesday, September 22, 2010 8:18 PM
  • You can open 2005 package in 2008 but not the other way round.

    Once you open a 2005 package in 2008 then you cannot open in 2005 again.

    Also, you cannot connect 2005  IS via SQL 2008 client. You need to export package to a file location.

    Thursday, September 23, 2010 7:01 AM