Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Copy SSIS packages from 2005 to 2008

Answered Copy SSIS packages from 2005 to 2008

  • Tuesday, September 21, 2010 6:41 PM
     
     
    Sign In to Vote
    0
    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.
     

All Replies

  • Tuesday, September 21, 2010 6:45 PM
     
     Answered
    Sign In to Vote
    0

    Hello Julliet,

     

    Backward compatibility is not supported as Error shows.

    Thanks

     
  • Wednesday, September 22, 2010 8:18 PM
     
     
    Sign In to Vote
    0
    Is there any other way to do this package between sql 2008 and sql server 2005
     
  • Thursday, September 23, 2010 7:01 AM
     
     
    Sign In to Vote
    0

    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.

    -ankur