SSIS in SQL2008/2005

Posted on 2009-04-25
Medium Priority
Last Modified: 2013-11-23
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.
Question by:ksfok
LVL 75

Accepted Solution

Anthony Perkins earned 1000 total points
ID: 24234344

Author Comment

ID: 24234776
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.
LVL 22

Assisted Solution

dportas earned 1000 total points
ID: 24234974
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.

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
The viewer will learn how to implement Singleton Design Pattern in Java.
Suggested Courses
Course of the Month15 days, 21 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question