Deploying SSIS package from SQL 2008 in SQL 2005

Posted on 2011-05-04
Last Modified: 2013-11-10
Potentially silly question, so please no laughing :)

Up to now, I have only built DTS packages and have not ventured into the brave new world of SSIS.  That is about to change.

My question is, if I build an SSIS package using SQL2008, can I deploy that package on SQL2005, or will the package be incompatible?

If the answer is, "yes, they are compatible, but...", then please outline for me what the pifalls are, such as features that would not be supported, or extra steps I would need to take to ensure that backward compatibility.


Question by:Patrick Matthews
    LVL 21

    Assisted Solution

    by:Alpesh Patel
    No, you can not host package to SQL Server 2005 those package are developed using SQL Server 2008.
    LVL 59

    Accepted Solution

    Patrick, that is my understanding also.  Once a SSIS package has been upgraded to SQL 2008, it is a permanent upgrade; therefore, the supported answer is "NO".  If you like to live a little dangerously and try out some cool things, check out  There are some caveats as noted by Simon Sabin.

    There is an associated discussion that went on at SQL Server Central where user successful used this CodePlex tool, but had to edit the XML of the package directly to remove references in the package to the variable named "System::ProductVersion" and update the OLEDB provider to "SQLNCLI.1" versus the native client version for SQL 2008 which is "SQLNCLI10.1".

    Hope that helps.
    LVL 92

    Author Comment

    by:Patrick Matthews
    Seeing as I will ultimately be deploying this to a customer, I think I'll choose not to live dangerously :)

    Thanks all!
    LVL 92

    Author Closing Comment

    by:Patrick Matthews
    Great job gang!
    LVL 59

    Expert Comment

    by:Kevin Cross
    Glad we could help, sir!  I should have mentioned earlier, the alternative is to build the package in SQL 2005.  You can run those in SQL 2008 and it will do a temporary upgrade in order to execute the package.  This should allow you to have one package you can use on both your SQL 2005 and SQL 2008 server.
    LVL 51

    Expert Comment

    by:Mark Wills
    Depends somewhat on how you build your SSIS package.

    If you need to do things on both then keep the SSIS stuff very very basic and simple and do the hard work by coding in TSQL / Stored Procedures and such like. Effectively use SSIS more like a scheduler and messenger. The recode the very simple part in SQL2005.

    But what are you trying to do ?

    Maybe write the TSQL to create the procedure, then to create a job, then use SQL Agent for scheduling and such like. There might be more than one way, not just the SSIS way.

    But if it must be SSIS, then no, not without some effort.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    755 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

    20 Experts available now in Live!

    Get 1:1 Help Now