SSIS in SQL2008/2005

Posted on 2009-04-25
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


    Author Comment

    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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
    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.
    Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
    This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now