Deploy packages developed in 2008 R2 in 2005 server

  • 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?

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

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

  • 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
  • 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