Post reply

Deploy packages developed in 2008 R2 in 2005 server

  • July 19, 2010 at 9:15 am

    #226968

    I am developing a SSIS package in 2008 R2 and my PROD Server has sql server 2005 installed on it. Do you think there will be any compatibility issues while deploying it on 2005 server?

  • July 19, 2010 at 9:18 am

    #1194949

    Yes, definitely. You will have to re-do your development in 2005. There is no 'Save As' function.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • July 19, 2010 at 9:47 am

    #1194970

    I dont have a 2005 sql server for developing. Is there any other way to solve this problem

  • July 19, 2010 at 9:55 am

    #1194972

    Unfortunately not. There's no backward compat option with SSIS, no save as, no downgrade. If you're deploying to a SQL 2005 server, you need to write your package in BIDS for SQL 2005.

    Been there, done that, had the fun of rewriting an entire package... 🙁

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 21, 2010 at 2:04 pm

    #1196475

    Unfortunately I agree with everything. Re-write is your only option. You might be able to cut and paste some raw code between but not objects.

    CEWII

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply