SSIS in SQL2008/2005

What are the differences that exist between SSIS of SQL2005 and SSIS of SQL2008? Can SSIS done with SQL2005 run without change in SQL2008? Thanks.
ksfokAsked:
Who is Participating?
 
ksfokAuthor Commented:
Should I simply upgrade an existent SQLServer 2005 to SQLServer 2008? What can I do about databases created with SQLServer 2005 (some under SQLExpress)? Thanks.
0
 
dportasConnect With a Mentor Commented:
My advice would be don't do an in-place upgrade for any production SQL Server.

Install a new instance and then backup from the old 2005 instance and restore to the new one. Upgrade of the database is automatic and virtually instantaneous.

2005 SSIS packages should work without modification in 2008.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.