Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Developing SSIS on 2008 Deploying to 2005

Author  Topic 

cknight44
Starting Member

3 Posts

Posted - 2008-09-24 : 12:59:14
I would like to upgrade my personal computer to SQL Server 2008 to get familiar with it. However, all of our corporate systems are still on 2005. Should I be concerned about developing SSIS packages on my 2008 local computer knowing that I will later deploy them to SQL Server 2005?

cknight44
Starting Member

3 Posts

Posted - 2008-09-24 : 15:52:33
I might have found the answer to my own question.
http://msdn.microsoft.com/en-us/library/bb522577.aspx

This talks about Side-by-Side Compatibility Issues and specifically says:
"...Once saved in the format that SQL Server 2008 Integration Services uses, packages can no longer be opened in the SQL Server 2005 version of Business Intelligence Development Studio, nor run by the SQL Server 2005 Integration Services tools."

This next link has other helpful articles about Integration Services Backward Compatibility, though not related to my specific question.
http://msdn.microsoft.com/en-us/library/ms143706.aspx
Go to Top of Page
   

- Advertisement -